Thread
:
Linking a cell to worksheets and workbooks
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Ron de Bruin
external usenet poster
Posts: 11,123
Linking a cell to worksheets and workbooks
Hi Kim
Manual you can do this
='C:\Data\[yourfile.xls]Sheet1'!$A$1
Try this macro if you have a lot of workbooks
http://www.rondebruin.nl/summary2.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Kim Thompson" <Kim
wrote in message ...
How would I reference a cell in a master document to other spreadsheets and
workbooks? I am looking to have a similar date that when is updated in the
master document will also appear on all spreadsheets? Not sure if linking is
the correct approach?
Thanks
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin