Populate a template for each customer
 

I have a template and need to populate certain fields with each customer's
data, then save it as the customer's name, in a certain folder. What I've
been doing is copying and pasting the each customer's data into a separate
sheet in the workbook template, which has fields mapped to the data in that
sheet. The data is just one row for each customer.

Is there code to filter by customer, and save the data to the template
sheet2 and save it as the customer's name, then reopen the template and do
for cutomer 2, etc.

Any help is appreciated.

Thanks