Blockwise sorting of lines

[CoSinus]

Hello together,
i have a bigger sheet and since the sheet is bigger it exceeds the maximum upload size so here is a link:

https://www.evernote.com/l/AGASdBWIh...hnFBI5ukf2vB4/

In this sheet, in the column AX (this column position can be different in the next quarter) from row 20 on (this row position can be different in the next quarter), there is the designation of the quarters from which the data are made.
If you look at the column AX, you can see that the quarters are mixed up in descending order.
For example
Quarter 8
Quarter 6
Quarter 7
Quarter 5

These and the corresponding lines should be put in a correct order:
Quarter 8
Quarter 7
Quarter 6
Quarter 5

But only until the next highest quarter number is reached, so in this case quarter 8.
Sometimes quarters can be missing, because the data in this quarter were not yet available.

Conclusion is, all rows should be sorted in the correct descending order until the highest quarter comes again.
The quarters can go from 1 to 16.
I have only shown 5-8 here.
But the principle is always the same: mixed quarters

Maybe somebody can help me to put the rows in the right order block by block.

If you have questions I can give you more information.

Thank you very much and sorry for the big problem.
I bow before you in gratitude

[hrlngrv]

Ambiguous.

If the 1st 3 lines were

Quarter 10
Quarter 3
Quarter 12

would that already be in correct order, or should it become

Quarter 12
Quarter 10
Quarter 3

or even

Quarter 10
Quarter 12
Quarter 3

?

If some instances of the 1st 3 lines above could be one block 'beginning' with Quarter 12 but other instances could be 2 blocks, sometimes Quarter 10 alone and Quarter 3 sorting below Quarter 12 while other times Quarter 3 sorting below Quarter 10 and Quarter 12 alone, there's be no deterministic way to sort blocks unless there were additional information in other columns.

[CoSinus]

Hi thank you for your question.
It should become
Quarter 12
Quarter 10
Quarter 3

Thank you very much

[jindon]

If you want to sort only Col.AX then

Please Login or Register  to view this content.

[CoSinus]

Thank you very much for this awesome VBA.
Could you please make this work on a current worksheet and not on the specific one called 'Konsolidierung'.

Can I use it on any other sheet, when there is a colum Ax filled with the quarter data like described above?

Thanks a lot for your answer & help

[jindon]

1) Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

2) Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

3) Change (for the safety of appearance of blank or any irregular data)

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[CoSinus]

I apologize very much for the late reply.
I have exchanged everything and it works.

Thank you very much that helped a lot.

Many greetings