Filter and export data with multiple criteria

Good Day everyone

I have a macro that is working perfect for one criteria that will extract all rows based on a text that is in a specific column to a new workbook.
My struggle here is to add some more criteria to be exported. My code below only extract all the rows containing the name "Vendor1" is in column 9,
but now i need to add "Vendor2" and "Vedor3.

Will greatly appreciate any assistance thanks!

Please Login or Register  to view this content.

Good day to all
I have attached a sample file FYI.
The code works good for one criteria, but i struggle to tweak it in order to have more than one criteria to export.
Any help will be greatly appreciated many thanks.