how do i maintain one worksheet from data from multiple worksheet

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Absolute References and worksheets 0
How to use multiple command button to copy user form data to multiple worksheet 0
Help? with extracting unsorted data from a worksheet, no blank lin 4
move a row of data from one work sheet to another using a formula 1
Excel formulas pulling from another worksheet changes when sorted 1
How do I find like data in multiple worksheets? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top