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)

I'm going to do some testing right now and see if it works properly, but just glancing over the code...WOW!

I wont be adding anymore data for the current vendors, but Ill be adding more Vendors and their info in the future.

Hi,

Remember the Vendors workbook and the file should be in the same folder on your drive.
Also i have bit of code that will exit the sub after it look for the first vendor.
it's Called "Exit Sub" remove it to test all vendor's workbook.
If you are leaving data in the TestFile you will need some way of knowing that you already populated the vendor's workbook. And, too, when you open the ven workbook the code will over write sheet 1, but will add to sheet.
Not sure if want it that way.

Real quick,

When you say set your path, am I adding the path to my TestData file or the forms? Also for sheet name? Just want to make sure Im putting the right information there.