synchronize worksheets with master worksheet 1

[JacobTechy]

I have 4 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.

 

[yogia]

Hi JacobTechy:

How about looking into using Data|Consolidation ... that should help accomplish what you want!

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com