Louise has attended:
Excel Intermediate course
Excel Intermediate course
Linking
Hi there, can I link single cells in one Excel workbook to another. The idea is to use the cost figures from one doc to update another. If so, how do I do it? Both Excel docs are on SharePoint. Thanks Louise
RE: Linking
Hi Louise,
Thank you for your question to the forum.
To link across workbooks do the following:
1. Open both workbooks and in the workbook 1 type = into a cell
2. Then go the workbook 2 and select the cost figure cell and press enter.
3. Now close workbook 1 and adjust the cost figure in workbook 2
4. Open workbook 1 to see the linked data update.
Moving forward, you will need to ensure both workbook filenames and saved locations are NOT changed.
Hope this helps
Kind regards
Martin Sutherland
(IT Trainer)
