Hi There,

I hope someone will be able to give me some tips!

I have 52 worksheets (one for each week of the year) each with about 6k lines on.

Each sheet has a list of products and their sales for that week. I am trying to create one master sheet with a total sale for each product. I have 60 different products.

The data is listed in the following way:

Product Sales
A 1
A 1
A 3
A 2
B 5
B 1
B 3
C 2

As every single sale is listed rather than just a total: Product A: 7 Product B:9 Product C:2. I am struggling to organise it.

I have been subtotalling by product name and then putting into a pivot table and then sort it from there. Is there a quicker/better way to summarise this data?

I have also tried consolidating the data but this doesn't seem to work due to fact that each sale is listed individually. Rather than just a summary of product A's sale etc....

I hope someone can assist!