ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel spreadsheets (https://www.excelbanter.com/excel-worksheet-functions/250029-excel-spreadsheets.html)

angeleyes

Excel spreadsheets
 
how do i copy data from one sheet to another so that if the info changes on
the first sheet it will automatically change on the second?

Eduardo

Excel spreadsheets
 
Hi,
you can have formulas in the 2nd spreadsheet. enter in sheet 2 cell a1 this
and them copy it

=sheet1!a1



"AngelEyes" wrote:

how do i copy data from one sheet to another so that if the info changes on
the first sheet it will automatically change on the second?


Stefi

Excel spreadsheets
 
E.g. =Sheet1!A1
entered in Sheet2 A1 shall give the value of A1 in Sheet1 in A1 in Sheet2.
--
Regards!
Stefi



€˛AngelEyes€¯ ezt Ć*rta:

how do i copy data from one sheet to another so that if the info changes on
the first sheet it will automatically change on the second?



All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com