Sorting on Multiple Columns

  • Thread starter Thread starter Gordon Forbes
  • Start date Start date
G

Gordon Forbes

Hi there,

I have a worksheet of 15,000 addresses and want to sort on
more than 3 columns. a small example is below i.e
A B C D E F
2 c New Road Braehead Balfron Rural
1 a New Road Braehead Balfron Rural
1 b Bog Road Braehead Cowie South
1 Old Road Braehead Plean North
2 f New Road Braehead Balfron East
2 New Road Braehead Balfron Rural

I want to sort by column F (zone) then by E (area)then by
D (add4) then by C (add3) then by A (add1) then by B (add2)

Can this be done by macro?

Thanks
Gordon
 
Hi
start sorting first by column A and B
and afterwards sort by the other three columns (F, E, D)
 
Back
Top