One change makes many changes

  • Thread starter Thread starter Ptrcip
  • Start date Start date
P

Ptrcip

Is there a way to make a change in a workbook and have it automatically make
the same change in worksheets in the same workbook?
 
What type of change?

Many formatting functions can be done to "grouped sheets".

Right-click on a sheet tab and "Select all sheets"

What you do to the active sheet will be done to all.

If you mean changes in values, you could "link" cells from one sheet to other
sheets.

A value change on the one will be reflected in sheets with "linked" cells.

e.g. On sheet1 in any cell type an = sign.

Switch to another sheet and select a cell and hit ENTER key.

Now you have a linked cell.

More on this in help>linking cells


Gord Dibben MS Excel MVP
 
Back
Top