Making changes automatically on multiple worksheets
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! |
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! |
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! |
All times are GMT +1. The time now is 04:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com