I'm having trouble getting my VBA to do an OR sort on two columns. The first sort works on Field 11 and the second sort works on Field 3, but if I try to combine them to get both the selected rows from Sort 1 and the selected rows from Sort 2, I get nothing.
Sort 1
*******
ActiveSheet.ListObjects("Table_IT_Data").Range.AutoFilter Field:=11, _
Criteria1:=Array("Smith, Jane", "Frias, Joe", "Adams, Cindy", _
Operator:=xlFilterValues
Sort 2
********
ActiveSheet.ListObjects("Table_IT_Data").Range.AutoFilter Field:=3, _
Criteria1:="=4041", Operator:=xlOr, Criteria2:="=4058"
My attempt at combining the Sort 1 and Sort 2
**************************************************
With ActiveSheet.ListObjects("Table_IT_Data").Range
.AutoFilter Field:=11, _
Criteria1:=Array("Smith, Jane", "Frias, Joe", "Adams, Cindy", _
.AutoFilter Field:=3, _
Criteria1:="=4041", Operator:=xlOr, Criteria2:="=4058"
End With
Any suggestions would be very much appreciated. Thank you!
Sort 1
*******
ActiveSheet.ListObjects("Table_IT_Data").Range.AutoFilter Field:=11, _
Criteria1:=Array("Smith, Jane", "Frias, Joe", "Adams, Cindy", _
Operator:=xlFilterValues
Sort 2
********
ActiveSheet.ListObjects("Table_IT_Data").Range.AutoFilter Field:=3, _
Criteria1:="=4041", Operator:=xlOr, Criteria2:="=4058"
My attempt at combining the Sort 1 and Sort 2
**************************************************
With ActiveSheet.ListObjects("Table_IT_Data").Range
.AutoFilter Field:=11, _
Criteria1:=Array("Smith, Jane", "Frias, Joe", "Adams, Cindy", _
.AutoFilter Field:=3, _
Criteria1:="=4041", Operator:=xlOr, Criteria2:="=4058"
End With
Any suggestions would be very much appreciated. Thank you!