1. R

    Trying to filter data incrementally based on user selection

    I'm trying to filter data based on a user's selection. The user may select more than one criteria. I have a column called "PRODUCTS" containing a number of values (e.g., PRODUCT 1, PRODUCT 2, etc.). I have 11 checkboxes (on the sheet itself, not a userform), each representing a product in that...
  2. A

    VBA - autofilter table when criteria is not in an array

    I am working on automating a report, and need to set filters for the consumers. I need to filter out items from some columns, and any other data needs to remain. Lastrow& = Range("A:C").Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row ActiveSheet.Range("$A$1:$AF" &...
  3. G

    VBA filter when search criteria is blank

    Hello, i use the following code, which might be long winded but works, I just need to change the criteria , so if range G17 is blank it just returns the results based on C11 and C20. currently it will return "no Matches found" Is there any code to do this? Sheets("cases available...
  4. W

    Auto Filter Help

    Hey gang! Can someone please help me understand why this isn't working: the error I am getting is "Run-time error '1004: Autofilter method of Range class failed." Thank you! Sub Criteria_Filter() With Sheets("MASTER") .Range("4:4").AutoFilter Field:=2, Criteria1:=Array( _ "<>TOTAL*", "<>0"...
  5. T

    Multiple criteria filtering

    Column A contains these values: Name a b c d e I want to filter some values, so use this: Range("A1).AutoFilter Field:=1, Criteria1:=Array("a", "b"), Operator:=xlFilterValues which indeed does return the values a and b only. Question 1. Why does this return no values? Dim...
  6. W


    Hello guys, here is my code for autofiltering but it doesn't seem to work. Any ideas? is it because the criteria is a string data? i've tried Criteria1:=Array(90000*, 19000*, 11000*, 24000*) but it doesn't work. TIA ActiveSheet.Range("$A$1:$AD$10000").AutoFilter _ Field:=17, _...
  7. H

    Macro non Contiguous Range

    I have code to use advanced auto filter to extract data from range B6:J & R6:R With ActiveSheet.Range("B6:J,R6:R" & Lastrow) I get application defined or object defined error and the code above is highlighted It would be appreciated if someone could assist me Sub Extract()...
  8. A

    define an Array in Filter as a String

    Hi, I want to define an Array as a string and fetch the values for the same from a cell in a autofilter, below is what i have tried so far but it's not working. can someone help existing code: Selection.AutoFilter ActiveSheet.Range("$A$1:$U$9995").AutoFilter Field:=5...
  9. G

    Msg box for nil return

    Hello, I have written this maybe basic code, to filter a sheet by criteria selected in 3 cells, this works fine, however rather than go to a blank sheet with just the head rows when there are no cases, i would prefer a msg box to just say, "no matches , change criteria and search again" I have...
  10. mole999

    Is there a way (VBA) Selection in Array

    I have ActiveSheet.Range("$A$1:$BE$6699").AutoFilter Field:=21, Criteria1:=Array( _ "(D/03/4V", "//", "12/95/E1", "15/19/95", "32/-2/09", "32/80/76", "61/40/07", _ "9E/09/NJ", "C1/No/-L", "GV/E9/N5", "-X-"), Operator:=xlFilterValues Is there a way to just use a IS NOT A...

Some videos you may like

This Week's Hot Topics