Copy a row, delete, then move on

[Dowsey1977]

Hi,

I have made progress with a macro that copies the contents of a row onto another sheet. I need to adapt this slightly so that it copies the first row (row 4) and then deletes the entire row, copies the new information, deletes and so on....

How would I get the macro to do this?? Also, I only need it to be done until A30 on the target sheet.

Thanks

N.B. I am using Range("A30").End(xlUp).Offset(1, 0). to find the first row on the target sheet.

[Norie]

Can you post the code you currently have?

[mdmackillop]

Instead of Copy use Cut.
For something like this, the macro recorder will get most of the steps. If you then need help editing/adjusting the recorded code, please post it and let us know what's required.
Regards
MD