Quote:
Originally Posted by charlesdh
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..
|
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.