Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter - Multiple Conditions?
Excel2003 ... Protected WorkSheet ... I do not know Macro Code ... I record
Code then do some creative cut/paste. Issue ... I have a template with "Auto-Filter" Switches set on every Col. I use a recorded Macro to accomplish my task (2 Conditions) ... However, now I need to Filter on more than 2 Conditions ... My present Macro looks like: Sub A_Test_Filter() ' ' A_Test_Filter Macro ActiveSheet.Unprotect Selection.AutoFilter Field:=2, Criteria1:="=0182", Operator:=xlOr, _ Criteria2:="=2321" Range("C2").Select End Sub I have Macro Buttons & I need the Auto-Filter Switches so is there a way to accomplish this with Macro Code that will not disrupt the present workings of my Template? Thanks ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filter for multiple columns | Excel Discussion (Misc queries) | |||
Search multiple cells with conditions, sum and auto populate! | Excel Worksheet Functions | |||
Summary Counts Functions to filter multiple conditions | Excel Worksheet Functions | |||
How do I filter with multiple conditions in one field? | Excel Discussion (Misc queries) | |||
Auto Filter Multiple Selections | Excel Discussion (Misc queries) |