Simple Macro to Move and Paste

[ScabbyDog]

I have the below code. I want so that if column C row i has the word NAME in it then I want to copy cells D & i + 1 : H & i + 1 and then paste the values into D & i. I then want to delete the entire row i + 1.

Am I close?

Please Login or Register  to view this content.

[stnkynts]

Very close:

Please Login or Register  to view this content.