Couple of things...

After the first workbook is created and copied, the macro doesnt populate anymore workbooks after that. It creates, saves but everything is blank.

Also, I understand it wont work for Vendors only with one line, but it didnt create a workbook for the last vendor.

Any suggestions?