![]() |
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? |
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? |
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