Macro for numbering several levels

[testre01]

Hello.
I have a problem with a macro.
I need a macro that will print the numbering in column A depending on the level of the grouped row.
There are rows grouped into several levels (for example, 3 levels, but there may be more)

Files in attachment.
TC_BOM_01 - FINAL - this is how it should look like.
TC_BOM_01 - MAIN - file on which the macro should be launched.

I would be very grateful for your help :)

[arnelgp]

see if this is what you need.

[Bob Phillips]

arnelgp has given you a working solution, but ... this seems so wrong to me.

You are using a visualisation to determine what your result should be. There should be something in the data that determines what the level of the BoM is, it is too easy to get the outlines wrong and mess up.

Always data!

[testre01]

Hi.
It works!!
Thanks :)