Sub Order()
LRow = Range("D" & Rows.Count).End(xlUp).Row
Range("A2").Select
ActiveWorkbook.Worksheets("WS1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("WS1").Sort.SortFields.Add Key:=Range("L2:L" & LRow _
), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
ActiveWorkbook.Worksheets("WS1").Sort.SortFields.Add Key:=Range("I2:I" & LRow _
), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortTextAsNumbers
ActiveWorkbook.Worksheets("WS1").Sort.SortFields.Add Key:=Range("P2:P" & LRow _
), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("WS").Sort
.SetRange Range("A1:A" & LRow)
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply End With
End Sub
Bookmarks