I just took over a business that is in a huge mess.
I get a weekly sales report. In each report every sku that is sold, stold or lost is reported and if we find one that was lost the week before. (I am trying to build in inventory controls) Right now I don't have the ability to change the sales report. We have over 300 sku's but only sell about 30-40 different ones in a week.
What I want to do is have a first worksheet that the sales report can be in and I want to populate each sku on a sub worksheet will all the information for that sku.
Is there a way to do this, or a better way to accomplish having the sales data for each sku on a different worksheet?
Thanks
Bookmarks