Sorting

[Patrick Simonds]

Any one know of a way to sort by 4 key's

Key1:=Range("N2"), Order1:=xlAscending,

Key2:=Range("A2"), Order2:=xlAscending,

Key3:=Range("S2"), Order3:=xlAscending,

Key4:=Range("T2"), Order4:=xlAscending,

 

[Myrna Larson]

Two sorts are required. Sort first by Key #4 (T2). Then sort a 2nd time with 3
keys, #1 = N2, #2 = A2, #3 = S2

 

[Chris Ferguson]

How about adding another column say 'Z' and concatenate the other 4 columns
and then doing one sort on 'Z'?

Z2 = +N2 & A2 & S2 & T2

Chris