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 helplinking cells


Gord Dibben MS Excel MVP


On Fri, 1 Feb 2008 18:37:00 -0800, Ptrcip
wrote:

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?