Hello Community!

First of all, sorry for the title, I am not sure how to describe the problem shortly.

I have attached a simplified excel sheet to demonstrate the task I want to have done.

test2.xlsx

Column A - unique identifier, based on location of the "group"
Column B - Main group (not unique)
Column C - Sub group (unique)
Column D - Names (each sub-group can have from 1 to infinite names)
Column E - Amount (one for each name)

I want it to sort based primarily on column B and secondarily on column C. When sorting, I wont the whole "group", illustrated with the black border, to move together into the correct order without any changes. Don't consider any of the formatting, the only purpose is to illustrate what I want. Besides, it is not important to update Column A when rearranged, I can easily do that in VBA myself.

The purpose is to have everything from the main group shown together, so when a new entry is added, I can update the list automatically with the click of a button.

I hope anybody have a solution or at least a clue! I know basic VBA.

Thank you in advance.