how to sort grouped data?

Originally Posted by popipipo

all put it in a macro

thanks a lot!
however, i found it difficult to fit into my data
attached is what i really want to do
I tried to do the ascending instead of descending in the macro, but it does not give what i want
sorry for the inconvenience caused