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)

Isn't that what the attachment in post #9 above does?


If you double click J8, then B9:AE45 are sorted ascending by J9:J45 and J9:J45 are shaded red

Double click J8 again and then B9:AE45 are sorted descending