VBA - Filtering via List from Column

Good Day,

I've been by my computer with a VBA/Excel Workbook for the past three hours and cannot figure out why It is not filtering correctly.
I have a list of Card Numbers that I want to filter out. If it's not on the list then move it to a different sheet. If it's on the list then I want to keep it on the sheet.

It seems I am having trouble with the "Diesel" portion of the filtering process. Reefer seems to be working just fine.


It will filter out most of the criteria but not all of it.

Important:
Card Numbers that I want to filter out are in Cells B2:B100
A3:A are the card numbers from the report that need to be processed

Here is what I have so far.

Please Login or Register  to view this content.

Originally Posted by GooberMcGee

It will filter out most of the criteria but not all of it.

When I see a comment like that, the issue often has to do with both the code and the nature of your data. We probably can't help you without an example workbook with data that illustrates the problem.


Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Heya,
I still need help with this;

I am trying to use "Filtering Sheet" to select "Unfiltered" and go through Column A on each sheet of "Unfiltered" and if numbers match Column A on the "Filtering Sheet" then keep them there, if not move the row that has the unmatched number to a new sheet then make it nice and neat then save the workbook as a new workbook.

Thanks

Please Login or Register  to view this content.

You're welcome.