Universal Worksheet Changes

  • Thread starter Thread starter Dick Bell
  • Start date Start date
D

Dick Bell

I have a workbook that has several identical worksheets that update to one
master sheet.

If I want to change a formula or make a chance in the worksheet is there any
way I can make the change universally in all worksheets instead of doing it
to each individual sheet?

Thanks!
 
If you group the sheets all changes done in one sheet will be done in the
other sheets as well, just remember to ungroup the sheets when you are done
 
Hold down the Ctrl button and select each of the "identical worksheets"
that you wish to make the changes in. Now each edit will apply to all
selected sheets.
 
Back
Top