*Dumb newbie* How to automatically import data from 1 workbork to another

  • Thread starter Thread starter Hosh
  • Start date Start date
H

Hosh

We have two workbooks maintained seperately.

Workbook 1 has a cell that has a total of a column that needs to be inserted
in workbook 2 daily.

My present procedure is to:
Open book 1, look at that total, write it down.
Open book 2, enter that total into appropriate cell in book 2.

Is there any way to automate this? Something like: Just by opening book 1,
it imports the data from that cell in book 2?

Sorry for the really newbie question. I hope I asked correctly.
 
Just enter the reference to the cell in book2 as follows:

='Filepath\[Filename]Sheetname'Cell

EG:

='C:\[Book1.xls]Sheet1'!A1

Hth

Jon
 
Go to workbook 1 and copy the cell that you want.
Go to workbook 2 and select the cell you want the data copied to and then
click Edit - paste special - paste link.

Now whenever you open workbook 2 it will update automatically from workbook 1.

Mike
 
Thanks!
That works great.
1 question though. Is there any way to eliminate the dialog box that asks if
you WANT to update from the links?
It would just be a little bit better if it just did that automatically.
 
Back
Top