Grouping rows (with VBA) depending on three levels/columns

TobiasTEST.xlsm

My knowledge was not suffient for this but maybe there is someone out there with knowledge/experience for this?

I have a list with seven columns (se enclosed file "Sheet1"). The three first columns describe which level of a Project the row belongs to. I would like to be able to run a macro to create a grouping (outline) for these levels automatically. The result should look like "Sheet2" in enclosed file.


(The real list is 4000 rows therefore I need a macro).

Thanks in advance for any contribution
Tobias

hi

The modified file does what you need.

Please Login or Register  to view this content.

Hi,

Thanks for contribution, but did you test the code on "Sheet1"?.
This code does not work in the example, when I am testing. It is looping around and do not stop (wait for over a minute).
It seems like the first grouping was made and then the macro get stucked.
Maybe it is a small change to done to make it work?

Hi

There must have been a hidden row when you ran the macro.

I have added 5 lines to make sure that there are no grouped or hidden rows.

Try it now,