if cell values are same,then combined it.

dear friends,here i have attached my document.column "D" to "I" any values are repeating in any other row then Column "J" values & column "K" values should combined & repeated rows should delete.it should same like my attachment second sheet,pls make macro for this,thanks....

Originally Posted by tony h

I presume you mean columns A to I (not just D to I)

no friend "D" to 'I" is correct.
column "A" order date
column "B" order no
column "C" customer name
we going to compare all these thing that will never match with others.if same thing available in other order i need to combined it.