View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RONZANDER RONZANDER is offline
external usenet poster
 
Posts: 4
Default 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?