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