Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro filter multiple criterea
Hello,
I've been searching the forum for a while but i cant find a right solution. I have this macro: Sub filter() Sheets("KAM").Select Selection.AutoFilter Field:=12, Criteria1:="=ANLAGE", Operator:=xlOr, _ Criteria2:="=PE", Operator:=xlOr, _ Criteria3:="=ED03" End Sub I would like to have a macro that filters multiple criterea (e.g. "ANLAGE", "PE", "ED03"... etc) The first two was no problem but when i wanted to add a third one and a fourth one it gives an error. In the end i would like to have two buttons that are attached to the macro. When clicking the button it show different filtered lists Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to pull data with criterea for placement on a new sheet | Excel Discussion (Misc queries) | |||
Creating a macro to filter data on multiple sheets | Excel Programming | |||
how do i countif on multiple criterea? | Excel Worksheet Functions | |||
Macro: Filter Multiple header then extract to Multiple Files | Excel Discussion (Misc queries) | |||
Create macro to filter on multiple criteria | Excel Worksheet Functions |