P Ptrcip Feb 2, 2008 #1 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?
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 Feb 2, 2008 #2 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
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
