Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm sure this will be a simple solution, just after figuring out how to get
the Split Sheet macro working for me, my brain's a little fried right now. I have one long report that prints out to a single worksheet. I used the Split Sheet Macro (a lifesaver) to create a new sheet after every hard page break. The only problem is the header rows (rows 1-6) are only on the original sheet and the first broken out sheet (Sheet2). How can I copy these rows and insert them into the first six rows in all sheets in the workbook? And as a bonus, if I could get them to not recopy into Sheet2 again, that would make life a little easier. Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
copying formulas when inserting new rows | Excel Discussion (Misc queries) | |||
Inserting multiple rows and copying formulas | Excel Discussion (Misc queries) | |||
Inserting the same header/footer on all worksheets in a workbook | Excel Discussion (Misc queries) | |||
Automatically copying fomulae when Inserting rows | Excel Discussion (Misc queries) |