I need to filter 2 columns (from about 30) using VBA
Select Client (drop down box) &/or Select Contractor (drop down box)

I can select on either one using
Range("client").Select
Selection.AutoFilter Field:=1, Criteria1:="*" & Range("$J$4") & "*"

but how do I select for combined Client 1 & Contractor A
We have an issue with either multi client or multi contractors on same
project
hence wildcard. I have tried:
Range("contractor").Select
Selection.AutoFilter Field:=1, Criteria1:="*" & Range("$j$2") & "*",
Operator:=xlAnd
Range("client").Select etc - but no luck