ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i maintain one worksheet from data from multiple worksheet (https://www.excelbanter.com/excel-worksheet-functions/40206-how-do-i-maintain-one-worksheet-data-multiple-worksheet.html)

Nensie Michel

how do i maintain one worksheet from data from multiple worksheet
 
i want to maintain one main worksheet with ALL the info and separate it into
multiple worksheets. when i make changes the the multiple worksheets (within
the same spreadsheet) i want the same changes on the main worksheet.... is
this even possible.

David Billigmeier

Yup, just click on any cell in your main worksheet, type an "=" sign, click
over to any other worksheet, and click the cell you want to reference.


--
Regards,

David Billigmeier



"Nensie Michel" wrote:

i want to maintain one main worksheet with ALL the info and separate it into
multiple worksheets. when i make changes the the multiple worksheets (within
the same spreadsheet) i want the same changes on the main worksheet.... is
this even possible.



All times are GMT +1. The time now is 07:39 AM.

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