Trouble filtering on two columns with VBA

[LAAdams17]

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!

 

[steve the fish]

How about:

With ActiveSheet.ListObjects("Table_IT_Data").Range
    .AutoFilter Field:=11, Criteria1:=Array("Smith, Jane", "Frias, Joe", "Adams, Cindy"), Operator:=xlFilterValues
    .AutoFilter Field:=3, Criteria1:="=4041", Operator:=xlOr, Criteria2:="=4058"
End With

The macro recorder would be your friend here.

 

[LAAdams17]

How about:

With ActiveSheet.ListObjects("Table_IT_Data").Range
    .AutoFilter Field:=11, Criteria1:=Array("Smith, Jane", "Frias, Joe", "Adams, Cindy"), Operator:=xlFilterValues
    .AutoFilter Field:=3, Criteria1:="=4041", Operator:=xlOr, Criteria2:="=4058"
End With

The macro recorder would be your friend here.

Hey, thank you very much! Appreciated!

 

[LAAdams17]

HOWEVER, the above solution works as an 'AND' condition: the data needs to fit both the two AutoFilter lines to be included.
What I'm looking for is the OR solution: if either of the two AutoFilter lines is true then include the rows.

 

[steve the fish]

If im understanding thats not how autofilters work. They always work as an 'and' for separate columns in the same table. You can have 'or' in the same column but if you want to use two columns then they use combinations. So you can have:

(Column1 = "ABC" or Column1 = "DEF") AND (Column2 = "GHI" or Column2 = "JKL")

but not

(Column1 = "ABC" or Column1 = "DEF") OR (Column2 = "GHI" or Column2 = "JKL")

You could create a formula in a helper column producing a TRUE or FALSE result based on your conditions then filter on that instead.