synchronize worksheets with master worksheet

O

oig01

I have four separate worksheets named a, b, c, d which the data for
each one is combined in a fifth worksheet called master all on the
same workbook. I am trying to make it so when I update data from any
of the a-d worksheets the changes also update on the master worksheet.
 
D

Dave Peterson

This is fraught with danger.

Excel doesn't do this very well at all. And I bet no matter how much you
(anyone!) work on it, it would never work when you handed it to a user.

I try to keep all my data in one location.

If I need other reports based on that data, I'll use some sort of
filtering/sorting if possible.
 
A

AKphidelt

If the data is perfectly aligned then you can do stuff on Sheet d like

=SUM(Sheet a!:Sheet b!A1)
 

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

How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Embed the same Excel multiple times 0
Syncing between source worksheet and dependent worksheets 0
How to update a value from a linked worksheet back to the master worksheet? 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to update data from linked worksheet back to a master worksheet? 0
index-match function across different worksheets 0

Top