Hi All

I want to ask for VBA Code or function in Excel for this condition:

I have 5 columns as below:
Table I
Brand Manufacturer Variant Packsize Value
A AAA Orange 3x400 500.000
B ABA Guava 5x150 150.000
E EEE Apple 2x250 200.000
C AAA Orange 6x500 200.000
D DAE Orange 7x200 250.000
A AAA Orange 3x400 350.000
E EEE Apple 2x250 200.000
A AAA Apple 3x400 350.000

and i want to change that table to this table:
Table II
Brand Manufacturer Variant Packsize Value
A AAA Orange 3x400 850.000
B ABA Guava 5x150 150.000
E EEE Apple 2x250 400.000
C AAA Orange 6x500 200.000
D DAE Orange 7x200 250.000
A AAA Apple 3x400 350.000

which:
- Table I has rows with same columns (Brand, manufacturer, Variant,Packsize)
Brand Manufacturer Variant Packsize Value
A AAA Orange 3x400 500.000
A AAA Orange 3x400 350.000
E EEE Apple 2x250 200.000
E EEE Apple 2x250 200.000

and in the Table II, i sum value for row with the some same columns
A AAA Orange 3x400 850.000
E EEE Apple 2x250 400.000

Please help me on this.
Thanks a lot for your help