Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making prices appear automatically when a value is selected | Excel Discussion (Misc queries) | |||
Automatically Updating Data from Multiple Worksheets into One | Excel Worksheet Functions | |||
automatically making a copy of a sheet | Excel Worksheet Functions | |||
automatically making a copy of a sheet | Excel Worksheet Functions | |||
How do I automatically alphabetize multiple worksheets in a singl. | Excel Discussion (Misc queries) |