Need to sort/group locations in sheet1 based on order criteria provided in sheet4

[aleanboy]

Hi All,


I have a macro code which will create the report as shown in Sheet1.
Now once the report is generated in sheet1, I would like to group the locations & insert few rows in sheet1 based on the order criteria shown in Sheet4. So that my final report should be present as shown in Sheet “Summary”.

Please advise what else should I include with the below code

Please Login or Register  to view this content.

[aleanboy]

Please advise with a macro code for above request