Advanced Filter using Criteria Range not picking up all criteria

Hi All,

I've inherited a block of code and needed to change the front ends column structure, thus requiring me to update some of the code. However, when I was finished updating everything, my Advanced Filter using the Criteria Range wasn't picking up all of the criteria needed.

Process: in the Drivers tab, when I run the "Update Drivers" macro button in the first row, the code is suppose to reference the "Advanced Filters" sheet (A2:B5), then cycle through the "P MFI" sheet. When it gets to the "P MFI" sheet, based on the criteria, its suppose to copy and paste (to the Drivers sheet) any row that has an "A/a" (found in column A) or if the "Prob %" field (found in Column I) is either 90 or 100.

Issue: When I execute the Drivers Update macro button, only rows that have an "A/a" are copied and pasted into the Drivers sheet.

Example: Go to the Drivers sheet, run the "Update Drivers" macro button and you'll notice that only Company 2 and Company 8 are copied over (including placeholders which are not a part of this troubleshooting session). The solution would include Companies 1, 6 and 10 (in addition to the rows that have an A/a), which do not have an "A/a" in the first column, but do have a Prob % of either 90 or 100.

The code is located in the Drivers_Update module in the attached file. I've also screenshot the exact line of code that is using the Advanced Filters Criteria Range functionality.

Again, the three sheets that you'll need to use in troubleshooting are "P MFI", "Drivers", and "Advanced Filters".




Your help will be most appreciated, as I am at a complete loss!

Thank you very much,

Kenneth

Have you tried manually filtering the data using your criteria? Do you get the records you expect?

First the Prob (%) field name has a line feed in it, so the field is not being found. Make sure the column header text is identical.
The numeric values should not use wildcards. either =100 or =>100 depending on what you actual mean by *100*