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!