populate a different workbook

[Guest]

any idea how would you reference a different workbood. here is the problem. I
have one workbook that contains infor. that will be changed over time. I am
trying to make the change populate to another workbook. how can this be done.
thank you.

 

[davegb]

Open both workbooks. There are several ways to do this. Probably
depends on how much data you're copying.
If it's only a few cells, open both spreadsheets. Put an = sign in the
cell you want to transfer the data to (target sheet), then click on the
cell you want to copy (source sheet), then click on the enter button
(checkmark) on the entry line in the target sheet. The 2 cells will be
linked.
If you want to copy a large area of a spreadsheet, click and drag over
the data you want to copy in the source sheet. Click on Edit, Copy. Go
to the target sheet, highlight where you want to data to go, do an
"Edit, Special, Past Link". The 2 spreadsheets will be hot linked.

 

[Tom Ogilvy]

Depends on what you mean by change and what you want populated. The easiest
would be to go to the destination workbook and create a cell link back to
the workbook that is going be changed

="'C:\My Folder\[My File.xls]Sheet1!A1"

then the cell with this formula would update whenever the book containing
the formula is opened and you answer positively to update links (if asked).

 

[Guest]

thank you your response helped.

 

[Guest]

thanks tom

Depends on what you mean by change and what you want populated. The easiest
would be to go to the destination workbook and create a cell link back to
the workbook that is going be changed

="'C:\My Folder\[My File.xls]Sheet1!A1"

then the cell with this formula would update whenever the book containing
the formula is opened and you answer positively to update links (if asked).

--
Regards,
Tom Ogilvy

any idea how would you reference a different workbood. here is the problem. I
have one workbook that contains infor. that will be changed over time. I am
trying to make the change populate to another workbook. how can this be done.
thank you.