Hi,

Prior to this modification each time you open the vendors workbook the code will over write sheet1. The reason is we have the Fpass set to false when you open it.
To over come this I add a bit of code to looks at sheet1 to see if it is already populated. If it is the the code will not over write the existing data.