Hi All,

I have a drop down list in Cell A3 of a spreadhseet. This list contains the names of all my customers.

Is it possible to loop through this drop down list (created via Data>Validation) and for each name in the list run a macro called do all and save the file under the name in the drop down list. I.e. Each name in the drop down list will have its own workbook.

Thank you for your help