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
see if this is what you need.
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!
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Hi.
It works!!
Thanks
Posting Permissions
Reply With Quote
