Sort Function with a Twist

[John]

Is it possible to Sort 'blocks' of data with the Sort function. A simple
example might explain

I have blocks of data, all relating to itself within the block, starting in
A9 and continuing to O30, then the next block starts at A31 to O52. My sort
cell should be A9;A31 etc

FYI cells A10:A30 are blank as are cells A32:A52

Common thread is relative formulas in all blocks and each block starts 23
rows from the previous Sort key i.e. A9; A31 etc

Thanks

 

[Charlie]

The only way I know of sorting by blocks is one block at a
time. If the sorting is something that is done frequently
and according to you post the blocks are constant then
consider recording a marco. You can do this during the
first sorting of blocks and then run the marco when needed.

Charlie O'Neill