How do I take data from one workbook and enter it into another?

  • Thread starter Thread starter soconfused
  • Start date Start date
S

soconfused

I have two distinctly different workbooks. I am trying to grab information
from one workbook and enter it into another. I need the workbook B to look
for the information in workbook A and enter it into specific columns. Is
there a formula I can use?

Thanks
 
Copy the cell from the source workbook and Paste Special->Paste Link in a
cell of destination sheet
You will get a formula like
=[Book1]Sheet1!$A$1
 
I have to do this on a monthly basis and I want it to find the data
automically. The workbook B is a workbook that has at least 10 sheets and
1000+ lines of data on each sheet. I need a formula to find the data.

Thanks
--
DMM


Sheeloo said:
Copy the cell from the source workbook and Paste Special->Paste Link in a
cell of destination sheet
You will get a formula like
=[Book1]Sheet1!$A$1

soconfused said:
I have two distinctly different workbooks. I am trying to grab information
from one workbook and enter it into another. I need the workbook B to look
for the information in workbook A and enter it into specific columns. Is
there a formula I can use?

Thanks
Click to expand...
Click to expand...
 
Your request is too vague.

Safely assume we cannot see your workbookB and the data you want transferred
from workbookA

Now try to provide some details.

Find what from where and to which cells will the transfer take place.


Gord Dibben MS Excel MVP
 
Okay, here's an example.

Workbook A

Sheet 1

Part #, Customer, Catalog #, Date, Eng Hours, Eng Bid, Eng Act, Dollars,

Sheet 2


All the same columns except the part numbers are different

Sheet 3

All the same columns except the part numbers are different.


Workbook B

Part #, Eng Bid hours, Eng act hours, Eng std hours, Ctr bid hours, ctr act
hours, ctr std hours.

Workbook B is a once a month input. I need to find the data from Workbook A
and have it automatically come across to Workbook B. The column setup is not
at all the same. The parts that I've shipped for the month could come from
any worksheet in Workbook A.

I hope this explanation helps.

Thanks.
 
Back
Top