![]() |
linking worksheet information
how can i link the information from one spreadsheet to another, so that the
data will change on both pages when info is updated? |
linking worksheet information
"krys" wrote in message
... how can i link the information from one spreadsheet to another, so that the data will change on both pages when info is updated? Select the relevant cell in the destination sheet, type = to start the formula, go to the source sheet, select the relevant cell (which will include that cell's reference in the formula in the destination sheet), and accept this. -- David Biddulph |
All times are GMT +1. The time now is 05:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com