Making changes automatically on multiple worksheets

[aaorbin]

I have multiple worksheets in workbook where columns A,B, and C are all the
same. I would like to find a way that if I make a change or insert a new row
on sheet 1, these same changes are made on sheet 2 and sheet 3. Is there a
simple answer to this? Thanks!

 

[Mike Rogers]

aaorbin

By Grouping the sheets you want the same changes to you can make those
changes by doing one and the change will hit all that are grouped. Be sure
to ungroup because it will continue to hit all grouped sheets when you are
entering data.

Mike Rogers

 

[aaorbin]

Thanks. That is where I started, but is there a way to "automatically" make
those changes for just columns A-C as a constant, instead having to group and
ungroup those sheets every time?

 

[Gord Dibben]

You can link multiple sheets cell data to to a master sheet.

But inserting or deleting rows and columns cannot be linked.


Gord Dibben MS Excel MVP