Copying data between workbooks?
I am trying to link two documents.
In essence i have one document which will be updated regularly with
information. I need to have a second document identical to the first (i.e.
linked with = formulae), so as a user imputs information to spreadsheet A, it
update the information in spreadsheet B automatically.
The only way I can figure out to do this is individually clicking on
destination cell, entering = , and then clicking on destination cell.
Surely there is a way to do the whole document???
Any help is very gratefully accepted.
Thanks
|