Two Workbooks into 1 File??

S

Skip

I have two workbooks, each in its own file. The two files share common
data.
Can I somehow combine the two workbooks into a single file, AND somehow
get around entering the data twice into each workbook? Any help is
greatly
appreciated. Skip
 
P

pdberger

Skip --

Two things come to mind:

1) Simply copy the worksheets from one workbook into the other.

2) Redo the formulas in one workbook so that, when you open it, it looks to
the other workbook to get the data. To do that, open the both workbooks.
Select the cell in the 'target' workbook (the one PULLING the info). Start
the formula with the '=' sign, and then click on the cell in the 'source'
workbook (the one PROVIDING the info). You'll see what the formula looks
like. Only problem -- both workbooks have to be open in order for this
approach to work.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top