The set of data I have is sales by SKU (retail, so pieces of clothing) by week and the number of units sold in how many stores. I want to create a macro that takes that data and organizes it on a separate "dashboard" that my business partners can play with.
The data needs to be organized by the Sku, which months the sku sold in, and the # of stores it sold in. For our purposes, we have a name for each month, because we call them "flows", such as Summer 1, Summer 2 Summer 3 (May, June, July). We also have names for the # of stores, we call them store groups. If something sold in 150 stores, the store group would be L1, 110 stores it would be L2, 84 stores it would be L3.
I'd like for our business partners to copy paste the data into a tool, and have the dashboard display the information by department (such as mens denim- would have a certain number of SKU data underneath it), and show how many skus sold in each month, and what level (store group) it sold in.
I have an example of one someone else built but their code is buggy. I want to recreate.