Hello,
I have a data table consisiting of different products with
sales amounts & volumes. Any product can be included many
times. What I want to do, is to add up the amounts or
volumes of the same product. Using a pivot table,
subtotals in the VB code, slows down the process. Is
there any other way to produce a more efficient visual
basic code? The table and the result I want to achive:

Product Amount Volume
A 5 100 Eur
A 10 200 Eur
B 10 300 Eur
B 20 600 Eur The RESULT should be:

Product Amount Volume
A 15 300 Eur
B 30 900 Eur

Many Thanks,