Autofilter in macro stops working if i put third criteria

[zohaib]

Hello,

I want to filter column A so it will look like the example below.

When i use the formula below with only two criteria it works but when i add the third criteria it does not work.

ActiveSheet.Range("A:A").AutoFilter field:=1, Criteria1:=Array( _
"Entity.*", "Total Claims Processed*"), Operator:=xlFilterValues


This is the formula with third criteria. How do I make is work?

ActiveSheet.Range("A:A").AutoFilter field:=1, Criteria1:=Array( _
"Entity.*", "Total Claims Processed*", "Total Dollars Processed"), Operator:=xlFilterValues



Entity...................... AHH
Total Claims Processed...... 313
Total Dollars Processed..... 2
Entity...................... AMM
Total Claims Processed...... 823
Total Dollars Processed..... 15
Entity...................... ASJ
Total Claims Processed...... 240
Total Dollars Processed..... 2
Entity...................... ASL
Total Claims Processed...... 350
Total Dollars Processed..... 3
Entity...................... AWB
Total Claims Processed...... 238
Total Dollars Processed..... 2
Entity................... AHH
Total Claims Processed... 10
Total Dollars Processed.. 1
Entity................... AMM
Total Claims Processed... 20
Total Dollars Processed.. 6
Entity................... ASJ
Total Claims Processed... 8
Total Dollars Processed.. 130
Entity................... ASL
Total Claims Processed... 6
Total Dollars Processed.. 15
Entity................... AWB
Total Claims Processed... 4
Total Dollars Processed.. 20
Entity...................... AHH
Total Claims Processed...... 4
Total Dollars Processed..... 18
Entity...................... AMM
Total Claims Processed...... 3
Total Dollars Processed..... 14
Entity...................... ASJ
Total Claims Processed...... 3
Total Dollars Processed..... 3
Entity...................... ASL
Total Claims Processed...... 4
Total Dollars Processed..... 6
Entity...................... AWB
Total Claims Processed...... 4
Total Dollars Processed..... 18

 

[NARAYANK991]

Hi ,

Please make it easier for others to help , by uploading a workbook with the data and the code in it.

Narayan

 

[zohaib]

Hello Narayan,

I apologize. Please see attachment. Thanks

Thank you,
Zohaib

 

[NARAYANK991]

Hi ,

The Autofilter in the Excel worksheet ( menu option ) admits of only two criteria.

I think if you want a third criterion to be included , you need to use the Advanced Filter instead of the Autofilter.

See the following links for more details :

http://excel.tips.net/T003036_More_Than_Two_Conditions_for_Custom_AutoFiltering.html

http://www.mrexcel.com/forum/excel-...l-basic-applications-filter-3rd-criteria.html

Narayan

 

[zohaib]

Hello Narayan,

Thanks the 2nd link worked out perfect. Thanks

Zohaib

 

[jeffreyweir]

I'm in the process of working up some cool code that will let you filter Tables and PivotTables on as many criteria as you like, including <> and wildcards. It's pretty neat. Flick me a line at weir.jeff@gmail.com if you want to try the beta version. (I'm probably about 48 hours away from completing it).