Hello

I have a worksheet with a very long range of columns. I am trying to sort column pairs. Here are the details:

COL A COL B COL C COL D ... COL GY COL GZ
ROW1 1 23 1 34 ... 1 7
ROW2 2 19 2 38 ... 2 2
ROW3 3 45 3 67 ... 3 68
... ... ... ... ... ... ... ...
ROW40 39 25 39 43 ... 39 9

I am trying to sort as follows:

Sort COL B highest to lowest for column pairs COL A & COL B then Sort COL D highest to lowest for column pairs COL C & COL D... and so on and so on....

NOTE - The worksheet has alot of columns thus I do not want to have to manually select each column pair to sort. Please advise and Thank You!

BlueStar Cloud