Hello,
I will create this Excel sheet in max 1 day. From your post it is not clear if you want a way to enter this data and then to create the analysis sheet, or if you have the sales data in a database, and you want the Excel sheet to read them. In any case, I can do this.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA for 12+ years. As you can guess, I have created a plethora of such analysis sheets for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini