Sort Largest to Smallest For Column Pairs

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

Thank You! It looks like it works... I'll give it some test runs and confirm how accurate (there's quite a bit of data I'm processing)