One change makes many changes

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top