Data Grouping

[Howey]

Hi,

I have an Excel file which is downloaded from SAP BI strait to an Excel format, the first column is broken down to L1 in multiple rows and a summary row of L0, I want to add a data grouping to the L1 rows, when i select the rows it adds one group for the whole page so i have to manually select for example the first rows of L1 then select Data - Group - Rows which is a pain for over 500 rows of data, example below, Image 2 is what i want to end up with.

 

[JEC]

First: put headernames above your columns

Then:

Sub jec()
Cells(1).CurrentRegion.Subtotal 1, xlCount, 1, 1, 0, 1
End Sub

 

[Howey]

Hi, they are there just not on the screen shot,