View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
aaorbin aaorbin is offline
external usenet poster
 
Posts: 2
Default Making changes automatically on multiple worksheets

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?

"Mike Rogers" wrote:

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" wrote:

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!