Rows Grouping Help - VBA

[Chetan]

Hi There,

I am using MS Excel 2010.
Whenever I create a Group on Rows, bydefault it adds a PLUS sign buttons on left side of Column A below to the selected rows.
I wanted to be added this PLUS button on the Upper side of selected buttons.

Reference to the attached excel file.
Have figured out some sort of VBA code from Google to do a Rows grouping with the help of Helper column A.
As stated above, the last PLUS sign button is referring to Last Blank row. I wanted these PLUS sign buttons to be shifted above.

Any help in this regards would be appreciated.

Thanks in advance.


Chetan

 

[NARAYANK991]

Hi Chetan ,

Your subtotal row is above the group ; if you can move this row to below the group , then you can get the grouping + sign on the same row as the subtotal , and the final + sign on a blank row will not be present.

Narayan

 

[Chetan]

Hello Narayan,

Requirement is to have the Subtotal at Top only.

i am trying to workout some other tricks to do so.
Hope for better. If i could, will post it here.

till the time Try, Try and Try !!!

Thanks,
Chetan