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.
|