Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter multiple columns
Hi Saintsman,
add one dummy column where you combine criteria 1 and 2 to one singel criteria. arno |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering Multiple Columns | Excel Worksheet Functions | |||
Matching Multiple Columns | Excel Worksheet Functions | |||
Selecting different multiple columns | Excel Worksheet Functions | |||
Multiple Columns to Single Columns | Excel Discussion (Misc queries) | |||
AutoFilter - non adjacent columns | Excel Discussion (Misc queries) |