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.

When you look at my code try to follow what it is doing.
As for sheet names. If in the actual workbook you have a sheet name other that "Sheet1" then change it to the actual sheet name.
That goes for both Vendor and text data workbook

I have skype. If necessary..

Oops,

You need to add this bit of code to the main code. Yow will put it above the "Next Item"
Fpass = False

Otherwise sheet1 will not get populated when you let code run for all of the workbooks.

Sorry...

I added that piece to the code. Thanks!

Code populates fine, only problem is that it doesnt create a new file for each Vendor with the two populated sheets. I was hoping to see the code run and create new files for each Vendor.

I took off the "Exit Sub" to allow the code to work for all vendors.

Once complete, it fills out Sheet1, but only for the last Vendor. Im guessing its overwriting each Vendor.

Sheet2 is populated with the info of all the Vendors. I was hoping it would create individual sheets for each vendor instead populating one for all.

Will taks a look in a few minutes.

Hi,

We need to save and close the vendors worksheet before we open the.
As far as creating a "New Vendor" file I did not see in your post that you needed this.
I believe you need to create a template so if required you can create the new vendor.

Hi,

I revamped the file. Had some code that was not necessary.
Have placed a Msgbox when you run the code.

Attached Files

Test Data1.xlsm (22.1 KB, 8 views)

Thank you. I'll test it out later tonight.

HI,

I also changed the way the program looks at it's path. I set it to "Thisworkbooks path"
So any and all file that you run the code for must be in the same and folder on your hard drive.
Also, how go you input your data?

I tested the macro last night and this morning. Once I run it, it filters on the first vendor, the message box pops up, but that is it. It doesnt copy any information to the sheets.

Am I doing something wrong?

Thanks!

I was able to get the macro to run. Is there any way you can add a save as function after it runs for a vendor?

Lastly, can you make Sheet2 clear before adding new data for each Vendor? Right now it keeps adding it to the next row.

Thanks!

Hi,

My error. Should have tested further.
Check this copy. It should copy data to the workbook and close it. Then it should open next workbook. If the next Vendor does not exist you will get the Msgbox.

Attached Files

Test Data1.xlsm (22.2 KB, 7 views)