View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default Making changes automatically on multiple worksheets

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!