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

Hi,

Thanks for this code - it didnt work, I am just trying to find out why now (if I can). I know its moving the total row which I need to avoid (these lines must remain fixed) e.g. the rows above and below the total lines are the only data that needs to be sorted.

I notice also that when the data is sorted it becomes corrupt because of the formulas used. Is there any way it can copy and past the data to a new sheet first and then perform the sort?