I have a master worksheet where the user can select a customer name and the respective product and price will be displayed. I have used formulas which pull data from another worksheet.
There are more than 50 customers (as a DATA VALIDATION LIST). When a user selects customer A, the relevant product and price get displayed. Is there a way to create 50 sheets using a macro for all the customers listed in the Master Sheet along with the template.
Product A Price
Product B Price
Product C Price
Product D Price