VBA Auto grouping downwards

[ali raza]

Hi Experts,
With reference to this https://chandoo.org/forum/threads/auto-grouping-vba.38130/#post-257062 solution. I am facing a little problem with the code because in this code its drilling the data downwards and in my case its upward. for example in below data i want grouping on totals. Please help me to achieve this with same code as i might extend this into next level which is price range and actual price.

Department	Category	Sub-category
A	AB	ABA
A	AB	ABA Total
A	AB	ABB
A	AB	ABB Total
A	AB Total
A	AC	ACA
A	AC	ACA Total
A	AC	ACB
A	AC	ACB
A	AC	ACB Total
A	AC Total
A Total

 

[NARAYANK991]

Hi ,

Please upload your workbook with adequate data in it.

Narayan

 

[Marc L]

Hi,​

​

see the Sub Total Excel feature or attach before (raw data) & after (expected result) worksheets …​

​

 

[ali raza]

Here is the sample data where i need auto grouping on TOTALS for each column till price range. VBA code used in Chandoo's file is working where totals are on top but in my case totals are in Bottom. Please help me via modify this code. I will be thankful to you

 

[NARAYANK991]

Hi ,

How did you introduce the subtotals for the Price Range ?

Narayan

 

[ali raza]

Hi Narayan,
I just want to apply auto grouping for each total at department, category, subcategory & Price range level. its not about subtotals