ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Grouping without totals (https://www.excelbanter.com/excel-programming/316220-grouping-without-totals.html)

BenJose

Grouping without totals
 
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


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com