Dynamic Sorting

Hi,

On the attached file I have a list of projects which are sorted by region, the regions are:
TOTAL - EMEA – USD
TOTAL - Americas – USD
TOTAL - EMPG – USD

Within each region I would like to sort the data by column BX to show the most profitable projects at the top of the list. I can do this manually but ideally I would like an automated version if possible?

Is there any way (macro or formula) in which I can achieve this? E.g. a macro or formula which first defines it’s own index (additional rows will be added), can it be that it looks for each instance of “TOTAL” to define the index last row? Then it sorts, then it moves onto the next region and so on.

Any help is greatly appreciated.

Paul