Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row above subtotal
I need to insert a row above a subtotal row
[=SUBTOTAL(9,C$1:INDIRECT(CELL("address",OFFSET(C11 ,-1,0))))] rows 1 - 10 contain data row 11 = subtotal row 1-10 rows 12 - 15 contain data row 16 = subtotal 1-15 (Grand Totals) I need a macro that will insert a row above row 11 - which then becomes row 12 & then repeat as needed ie always insert a row above the subtotal row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Rows vs SUM() and SUBTOTAL() | Excel Discussion (Misc queries) | |||
How do I insert a subtotal? | Excel Discussion (Misc queries) | |||
Insert Subtotal button | Excel Worksheet Functions | |||
Insert a new worksheet after subtotal | Excel Worksheet Functions | |||
Sort, Subtotal, Label Subtotal, Insert row | Excel Programming |