Copy data and Deleting row

[rsaroj]

Hi All,

I am very new to Macro and VBA. Tried to look to old thread but have to admit that it is too difficult for me to understand the codes.

Here is my request.

I have 4 column.
A. Product ID
B. Po. NO.
C. Pcs
D. Amount
Sample refers.
I want to delete row where it has duplicate product ID. However, before deleting, I need data from col. C-D to be copied(move) to its previous row.

Or another word.
If Product ID - row x the same as row x+1 then, copy(move) data from col. C and col. D to row x.
Then delete row x+1 and so on.

I hope you guys can give me a hand on this. Thanks in advance.

[jraj1106]

Hi

Try this:

SAMPLE_Row_Delete.xlsm