HI,

I've gone as far as I can right now.
The code in this attachment will loop through column A for the vendors.
It should open the "Vendors" workbook. The workbook must be in the Vendors name. It can not be called "Form".
It will set a filter for the vendors.
I only tested for "A&B Company". Because that the only file I have.
It will populate sheet1 and sheet2.
You will need to change the "Path" in the code to your path.
I added a "Exit Sub" in the code so you can only test 1 vendor at this time.
Will you be adding more data to the "TestData" workbook for each vendor and leave the old data in place. Or when you done with the "TestData" will you clear it for new data?

Attached Files

TestData.xlsm (15.4 KB, 27 views)