how do i maintain one worksheet from data from multiple worksheet

N

Nensie Michel

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.
 
D

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.
 
Top