Hello,
I am new to VBA. I have a master spreadsheet that has data populated in columns A to G. I would like a macro to loop through the data in columns E:G copying the data in each row to another workbook called Vendors.xlsx that contains a worksheet with the same name as the value in column C. The data should be pasted special values in the first empty cell starting in B3.

For example. From the below data, the data in row 2, columns E, F and G, would be copied and pasted into workbook Vendors.xlsx, worksheet Vendor1. Data in row 3 would be pasted into the worksheet Vendor2.

Thank you in advance for any assistance.

Column C Column D Column E Column F Column G
Vendor # Location Address City State
Vendor1 1 Main St Philadelphia PA
Vendor2 3 XYX St New York NY
Vendor3 1 ABX Rd Seattle WA
Vendor2 1 G St Trenton NJ
Vendor4 3 Race St Philadelphia PA
Vendor1 2 1st St New York NY