Dowsey1977
06-07-2006, 11:07 AM
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.
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.