Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUbtotal
Hi All, I am having problems with my code. I am trying to subtotal by: 1) Column A - By Group Then 2) Column B - By Division Then 3) Column E - By Account The problem is the subtotal line for the last division is below th account total line even though the amounts are correct. For example m spreadsheet appears as follows: Div 1 Total - 100 Div 2 Total - 100 Acct Total - 300 Div 3 Total - 100 My subtotal code is: Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(7, 8 9), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True Selection.Subtotal GroupBy:=5, Function:=xlSum, TotalList:=Array(7 8, 9), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(7 8, 9), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=True Any help would be greatly appreciated! -- STEVE ----------------------------------------------------------------------- STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187 View this thread: http://www.excelforum.com/showthread.php?threadid=49157 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Sort, Subtotal, Label Subtotal, Insert row | Excel Programming |