How to loop through a customers' list and produce one file per customer with VBA 

Often we manage datasets in which customer information is reported on more than one row. This can be because we have different orders from the same customer 

In this post we explore a powerful technique allowing to create individual file per each customer 

We will go through the code that allows to loop through a customer database, creating distinct files for each customer—regardless of repetitions in the original list. 

The files will be conveniently saved in the same location of the original list. Once all the files are saved the can be used for different purposes such as being emailed to the individual customers as explained in the post How to send emails with attachments to multiple recipients 

Starting point is an excel workbook with a first sheet called "Customers" in which the customer information is reported.

The code will go through the following key steps:

1.  An array will be created containing the full customer list

2. The code wil loop through the array to identify all records containing name and surname of the same customer

3. A second array will be created where only the information of a specific customer will be copied 

4. The second array will be saved to a new workbook called with the customer name

The complete code is reported below