Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter Macro
I'm building an employee scorecard, but I want to filter by only the relevant
results, so I want to place a filter on a range of data to eliminate the values "0", "No data", and "No ranking". When I tried to record the macro, I instead came up with the following code, which didn't filter out the above 3 values, instead filtered FOR the remaining values (which are subject to change, depending on a number of things). Is there any way to correct this? Sub macFilterScorecard() ' ' macFilterScorecard Macro ' ' ActiveSheet.Range("$B$4:$C$172").AutoFilter Field:=2, Criteria1:=Array( _ "0.25", "0.65", "1", "104.00", "129", "137.38%", "5.29%", "5.50", "7,778", "79.69", "98", _ "98.50"), Operator:=xlFilterValues End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can this filter be done in a macro? | Excel Discussion (Misc queries) | |||
Filter Macro | Excel Programming | |||
Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
Need a filter macro | Excel Discussion (Misc queries) |