Sorry for confusion In above latest sheet I explain detailed as which I want output

if I double click row8 (Range B8:AE8)
Then Data sort as
Rows sorted by B9:AE45 (Asc & Des order)


if I double click row48 (Range B49:AE50)
Then Data sort as
Rows sorted by B49:AE50 (Asc & Des order)


if I double click row54 (Range B55:AE78)
Then Data sort as
Rows sorted by B55:AE78 (Asc & Des order)


Data sort each block / range not at one all sorting.




If Sorting at once all block/range in each sector then it is amazing for me but it is another Query/ideas.first I required as separate sorting if we success then next stage I will thinking of your great ideas sir & if will sort done then I will salute Sir