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


"Hosh" wrote in message
...
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.

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

"Hosh" wrote:

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.

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.



"Mike H" wrote in message
...
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

"Hosh" wrote:

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.