View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default 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.