Autofilter multiple columns
 

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

Autofilter multiple columns
 

Hi Saintsman,

add one dummy column where you combine criteria 1 and 2 to one singel
criteria.

arno

Autofilter multiple columns
 

arno
thanks for the effort - not really what I wanted to do
managed to solve immediate issue


"arno" wrote:

Hi Saintsman,

add one dummy column where you combine criteria 1 and 2 to one singel
criteria.

arno