copying row + 1 row below

[mokht]

Hi,
I have a code to deleting row + 1 row below

Please Login or Register  to view this content.

in this code we are looping in col "A" - Find all the values ("mokhtar") - then deleting row + 1 row below

my request : update the above code to copying row + 1 row below then paste data in D1

Any help would be greatly appreciated. Thanks in advance.

[PCI]

" copying row + 1 row below then paste data in D1"
it means for example you want to copy A3 and A4 to D1 and D2 ??

[mokht]

Mr PCI Thanks for the reply
I'm not clear enough in my explanation,
if we have a data in column A this data contain a word say " mokhtar " in many rows
i want to adapt the above code to :Looping thru column "A" to Find all values "mokhtar" then copying it's row and the row below then paste all in column "D"
Thanks in advance for all your help!!

[JOHN H. DAVIS]

You can't copy an entire row to Column D. Does this help?

Please Login or Register  to view this content.