Auto Sum for articles with the same name

[oeyandyprawira]

Hi,

I attached excel file, it has two sheets, sheet source and sheet result.

From source sheet there's dataA.jpg
and result sheet is the autosum for articles with the same name
B.jpg

Is there a macro for this solution,thx

Regards,
Andy

[zbor]

Use Pivot table

[zbor]

Right click - Refresh to refresh table

[oeyandyprawira]

Dear Zbor,
Thx, I knew the pivot table, but since I'm doing alot of these, using macro will be faster.

[AB33]

Try the attached.

[oeyandyprawira]

Try the attached.

Perfect AB33,thx