make the auto-filter work with field 1 and 3

[exceltadpole]

I am using 3 filters:

Selection.AutoFilter Field:=1, Criteria1:="=*PAID*", Operator:=xlAnd
to select all the rows which contain PAID in column 1

Selection.AutoFilter Field:=1, Criteria1:="<>*PAID*", Operator:=xlAnd
to select all the rows which do not contain PAID in column 1

Selection.AutoFilter Field:=3, Criteria1:="=*INVOICE*", Operator:=xlAnd
to select all the rows which contain INVOICE in column 3


How do I combine these into 2 filters:

to select all the rows which contain INVOICE in column 3 AND contain PAID in column 1

to select all the rows which contain INVOICE in column 3 AND do not contain PAID in column 1


(I don't know how to make the auto-filter work with different columns. Meaning field 1 and 3.)

 

[al_b_cnu]

Hi,

Cant you simply use something like
---------------------------------------------------------------------
Dim sFilter as String
. . .

If ????? then
sFilter="=*PAID*"
Else
sFilter = "<>*PAID*"
End if
Selection.AutoFilter Field:=1, Criteria1:=SFilter, Operator:=xlAnd
Selection.AutoFilter Field:=3, Criteria1:="=*INVOICE*", Operator:=xlAnd
---------------------------------------------------------------------------

HTH

Alan

 

[GorD]

The auto filter should do exactly as you require. it works for AND conditions across different columns.
You just select your criteria from the drop down list in your first column, then do the same on your second criteria column.

If you wanted an OR condition (across columns) you would have to use an advanced filter