How to get Excel to copy a master worksheet incorporating values entered by user

Hi Todd, welcome to the forum.
I like your enthusiasm and praise your intentions, go for it, Excel and especially VBA is great.
All you need is a lot of time a very patient partner, a lot of patience and perseverance.

I've read what you are asking. I downloaded the file and will take a look at it later today maybe this evening to see if I can grasp what you are wanting to achieve.

Maybe someone else picks it up too, there quiet a few a guys here on this forum that like these things too.

Regards,

Hi tsummers and welcome to the forum,

I think you are looking for a Pivot Table or an Advanced Filter solution for your first step. See the attached where I've done a PT on your left table. I believe using VBA to create new sheets isn't a great idea. Learn PTs and see if that is all you need.

Product PT filtered.xlsx

Hi there,
Thanks for the welcome Keebellah, and Marvin I like your idea of the PivotTable! I think that gives me some cool possibilities, but I think my main challenge is how to enable the user to enter the product codes of their choice and then get Excel to run all my formulas on the Master sheet based on their entry. Part of why I was going the route of getting Excel to spawn new worksheets for each product code (copying the Master) is that Master worksheet has a bunch of formulas with multiple steps - it needs to take their product code and search for it within multiple worksheets where the user will be importing sales data, email marketing data, and perhaps other data. Where it finds the product code it will return corresponding data like dates, order totals, etc. Then it runs some more analysis of that data which is what I want to eventually summarize on a Reports worksheet. So while the Pivot Table seems useful for filtering data to investigate trends in my dataset I'm not sure that it will help me to do this analysis that's drawing in values from multiple sources and performing numerous formulas based on those values.

Another key is that I'd like to set up some sort of automation so this can be used by different people within my company with various levels of expertise with Excel. So ideally I'd like them to just enter the date of the email send, the product code, and maybe a few other things and click "go" and have Excel do the calculations and reports without requiring the user to do any further data manipulation to interpret the results.

Here's what I want Excel to do automatically:

1) Enable a user to enter in their date/product codes on one sheet
2) Run the same list of calculations for each date/product code (referring to multiple worksheets containing source data inputed by the user)
3) Then capture certain resulting values from each of those calculations for a final report reflecting all the date/product codes

Perhaps you're right that creating new worksheets isn't necessary. My plan was to get VBA to initiate new worksheets based on the users input, name the sheets, transfer certain values into each sheet, and then refer to the calculated results from those sheets in a report. But maybe that's over engineering it.

Thanks so much!
Todd