need help pulling information out of sales report

[oddcarout]

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

[jeffreybrown]

First idea that comes to my mind is a vlookup, but seems more info is required here.

A sample workbook is always a good place to start...

[royUK]

PivotTable, Sumif or Sumproduct. Hard to say without seeing what you are working with