I have the following data inculded Customer, Invoice no., Part no and Qty.
In Invoice, there will be same part no., How can show the same part no. in
one and the qty will be sum.

Use marco or function...............any better methods????


e.g
customer Invoice no. Part no. Qty.
KATATA HK0811-0001 RK73H2ATTD 102F / 50000
KATATA HK0811-0001 RK73H2ATTD 102F / 40000
KATATA HK0811-0001 RK73B1JTTD 204J / 30000
KATATA HK0811-0001 RK73B1JTTD 204J / 5000

(I want the following result:)

KATATA HK0811-0001 RK73H2ATTD 102F / 90000
KATATA HK0811-0001 RK73B1JTTD 204J / 35000