Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!
Anybody have any macros handy to group a more than 1 columns without any totals. Using the below code: Range("A1").Select Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(20), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=False will create a group based on one column and it will display sub totals. But I dont want the subtotals and also the grouping should be on two columns. -Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Grouping totals together by month per customer | Excel Discussion (Misc queries) | |||
Grouping Totals | Excel Discussion (Misc queries) | |||
Grouping & Group Totals | Excel Worksheet Functions | |||
Sorting and grouping list totals | Excel Programming |