Very Unusual Sort Rows Needed
I have a worksheet that I need to sort the rows based on two columns.
Now before everyone tries to tell me how to sort using Excel's sort
function, I will state that it will not do what I need and this is why
and what I need to discover a macro to do...
Example:
A B
----- -----
200
300
100
200
100
300
200
100
300
etc, etc, etc
After "Sort" Macro:
A B
----- -----
100
100
100
200
200
200
300
300
300
And now for the fun part? The sort on data is NOT in column A & B, but
rather in columns M & N and must stay that way.
Any ideas?
|