ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   linking worksheet information (https://www.excelbanter.com/excel-discussion-misc-queries/91836-linking-worksheet-information.html)

krys

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?

David Biddulph

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