What would be the best way to filter a worksheet where I need to filter by If "this" or "this" but doesn't contain "this"
below im filtering a table looking for "Se Mo" or "Sc Qu" then wanting to exclude any rows returned that contains 2012.
Didn't think this would be this hard.
Suggestion?
.AutoFilterMode = False
With .Range("A1:H" & LastRow)
.AutoFilter Field:=5, Criteria1:=Array("=*Se Mo*", "=*Sc Qu*", "<>*2012*"), Operator:=xlFilterValues
below im filtering a table looking for "Se Mo" or "Sc Qu" then wanting to exclude any rows returned that contains 2012.
Didn't think this would be this hard.
Suggestion?
.AutoFilterMode = False
With .Range("A1:H" & LastRow)
.AutoFilter Field:=5, Criteria1:=Array("=*Se Mo*", "=*Sc Qu*", "<>*2012*"), Operator:=xlFilterValues