Sort Two Columns at a time

[joe_ll]

Hi all,

I'm pretty new to macros and whilst I've had some wins so far, I've hit a brick wall and was hoping someone could translate my logic into a working macro or at least point me in the right direction.

I have a sheet with several columns, grouped in pairs. What I want to do is sort each pair by the values in the second column.

The columns look something like this:

| A | B | C | D |
| Item1 | Val_1 | Item2 | Val_2 |
| foo | 26 | foo | 3 |
| bar | 12 | bar | 9 |

The pseudocode I've come up with looks like this:

-----
columnOne = A
columnTwo = B

WHILE there's still columns with values in them

sort (columnOne:columnTwo) by columnTwo descending with headers
columnOne+= 2 // i.e. offset 2 columns to the right C, E, H
columnTwo+= 2 // i.e. D, F, G

REPEAT
-----

I would greatly appreciate any assistance with this.

Thanks in advance,
Joe

[Paul]

Hi Joe, welcome to the forum.

Perhaps the following macro will help you out..

Please Login or Register  to view this content.

[joe_ll]

Paul,

You're an absolute legend, mate.

Thanks heaps for helping me out.

Cheers,
Joe