Worksheet updates

  • Thread starter Thread starter cherri isbell
  • Start date Start date
C

cherri isbell

Is it possible to have one worksheet automatically update
a master worksheet?? I have 8 worksheets, and I have one
master worksheet. When I make changes to one of the 8
worksheets, I want to know if I can set it up to
automatically update the master worksheet.
 
-----Original Message-----
Is it possible to have one worksheet automatically update
a master worksheet?? I have 8 worksheets, and I have one
master worksheet. When I make changes to one of the 8
worksheets, I want to know if I can set it up to
automatically update the master worksheet.
.
on your masterworksheet, begin the formula by pressing
Click to expand...
the equals sign, then go to the worksheet and click on
the cell that you want the masterworksheet linked to.
Then press tab and it will take you back to the
worksheet. This connects the two worksheets and the
master will automatically update each time that you enter
information on the individual worksheets.
 
Back
Top