• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Autofilter in macro stops working if i put third criteria

zohaib

Member
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
 
Hello Narayan,

I apologize. Please see attachment. Thanks

Thank you,
Zohaib
 

Attachments

  • Book1.xlsm
    14 KB · Views: 2
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).
 
Back
Top