populate a different workbook
 

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.

populate a different workbook
 

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.

populate a different workbook
 

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

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

populate a different workbook
 

thank you your response helped.

"davegb" wrote:

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.

populate a different workbook
 

thanks tom

"Tom Ogilvy" wrote:

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

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