Add sum of data based on 2 columns, and add the data to another worksheet.

[jasonms]

HI,

I have received a file from a customer, the file contains 17500 lines of products been shipped.
what I need to do is reduce this down.

how it should be filtered is by country code & then unique commodity code and all the totals added up to create one row.

Yes, I can do this via a filter but it takes so much time.

Is their a formula / VBA.

I can set up the document to filter the information so it is in order via a macro I suppose.
but is their a way I can add a formula to select the country code first then select all the unique commodity code and add the total values per column within the range selected and for this information to be added to another worksheet?

see images attached, colour coded only for the exercise.

the product information may vary but only slightly so it's not important which data pulls across any of the descriptions of the goods within that range is fine.

the file had 17500 lines, by country code then unique commodity code I managed to reduce it down to 131 lines.
the system I use to upload the data only accepts 150 lines.
It took to be quite some time, I would really like a solution to this, I will see many of these files and a long term solution would be amazing! thanks

 

[jasonms]

the product information ITEM NAME may vary but only slightly so it's not important which data pulls across any of the descriptions of the goods within that range is fine.