Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding rows to several worksheets
I want to insert a row in worksheet #1 and want it automatically to happen in
all the other sub-worksheets (2 - 10) in this workbook as well. Any idea? Regards |
#2
|
|||
|
|||
Hi Stefanie,
Group the sheets, either add sheets to the the selected sheets by holding CTRL and selecting another add sheets by hold ctrl+shift to add additional sheets through the one you click on right click of the sheet tab and choose Group all shees When you are finished you MUST ungroup your sheets as any further changes would also affect all of your sheets and destroy your workbook very fast. Right click on the sheet tab and choose Ungroup Sheets If you want to copy the formulas down from the previous row with a macro on all of the sheets you can see the insert rows and maintain formulas macro on http://www.mvps.org/dmcritchie/excel/insrtrows.htm which was designed for a single sheet but was modified to handle grouped sheets as well. Same thing as before UNGROUP sheets when finished. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Stefanie" wrote ... I want to insert a row in worksheet #1 and want it automatically to happen in all the other sub-worksheets (2 - 10) in this workbook as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
Adding rows of different info from separate worksheets into summar | New Users to Excel | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |