Macro for conditional grouping and formatting of certain rows

[alexpantex]

Hi everyone,

I am currently working on a project where I need to group all rows into 3 levels. Idea is that 1st level would be grouping by manufacturer, than for each manufacturer to group his brands, and in 3rd level for every brand to group items that belong to it. If anyone has an idea how to code this, please help, it would mean a lot to me, because sometimes I work with reports with 10000 rows and formatting can take a while.

 

[alexpantex]

this is what output should look like

 

[NARAYANK991]

Hi ,

Good that your workbook contains the desired output format. Can you upload the same workbook with the input data format , so that we can get an idea of how to go from what you have to start with , to what you want ?

Narayan

 

[alexpantex]

Thanks for quick reply. basically output follows the same order, just it's not grouped and formatted

 

[alexpantex]

this is the file

 

[alexpantex]

Hi guys, it's me again
Do you think this is doable, just to know if it's worth of trying