synchronize worksheets with master worksheet
If the data is perfectly aligned then you can do stuff on Sheet d like
=SUM(Sheet a!:Sheet b!A1)
" wrote:
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.
|