Thread: 2 level sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PVANS PVANS is offline
external usenet poster
 
Posts: 68
Default 2 level sorting

Good morning everyone

I hope someone can help me with this. I am trying to filter my worksheet at
2 distinct levels. Firstly, I am trying to sort the workbook in ascending
results in terms of column B. I managed to do this by recording the macro and
got the following code:

Selection.AutoFilter
Range("A1:AE144").Sort Key1:=Range("B1"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

However, once the workbook is sorted like this, I would like to further sort
the results in ascending values in terms of Column J. Thus keeping the data
sorted in terms of Column B... but further sorted in terms of Column J.

Really would appreciate the help

Regards

Paul