Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inserting Copied Row To Always Insert Above Sub Total
Hey, I'm having problems with a work sheet. I have a spread sheet which needs to have additional rows added always to just above the sub total row. When I try to run this as a macro the formulas are always copied to the same row, I can't get it to adjust to always insert into the row directly above the subtotal row which reference obviously changes every time I add a new row. any advice gratefully recieved. Thanks, James. -- Jamess ------------------------------------------------------------------------ Jamess's Profile: http://www.excelforum.com/member.php...fo&userid=7801 View this thread: http://www.excelforum.com/showthread...hreadid=483709 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a reference to lookup and insert a name | New Users to Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |