Hi,
I now have this file open vendors file and populate it. It will or should create a new vendor file and populate it. The code will also remove data in sheet2.
The repopulate it.
I created a "Template for the new Vendors".
You need to correct the path for the new vendor workbook. I made remarks in the code module for this.
Be sure you put all file in the same path!
|