Hi Team,
I need help to filter single column with multiple criteria.
I have attached a sample file for your reference:
1. I have 2 sheets in attached sample file (Summary & Ref)
2. ‘Summary’ sheet is where I need the output to be filtered upon clicking the ‘Apply’ button.
3. Column D is where I need the filter to be applied to display.
4. ‘Ref’ sheet has a list of criteria which I wanted to use them for filtering column ‘D’ of Summary sheet.
5. Note: The criteria list in the ‘Ref’ sheet keeps on changing, but it won’t exceed 2000 rows. Hence, let me fix the criteria range as A2:A2000 (which is in grey color). In the given sheet, there are 1801 criteria and the remaining are blank values.
My Requirement: When I click ‘Apply Filter’ button on Summary sheet, the table underneath it should filter column D with all the criteria listed in Ref A2:A2000
Please help me with a macro coding using filter function.
Bookmarks