Re: macro - to create new sheets from a data validation list
Quote from TheGlovner;799900
So you have 50 customers in a range (which you use to prompt the dropdown options) and you want to use each customer to create a single sheet per customer.
Is that correct?
Is there are good reason for creating 50 spreadsheets? I'm a little confused on the purpose.
Yes, you are right!
I want each customer in a single sheet. i.e., 50 sheets Currently it is in a drop down menu and the user has to select each customer to display the product information. It would be easy for the user if there are separate sheets for each customer as they can print the sheets, process the payments and also file the sheets for future reference.