Copy and paste row into next sheet, into next empty row??

[Statesman]

Hi All,

I've got this far, but when the row is cut from the first sheet and pasted into the next it just over rights the last row pasted there instead of pasting the next row down, any help resolving this would be MUCH appreciated. Thanks. Adam.

Please Login or Register  to view this content.

[arlu1201]

Since you have this code

Please Login or Register  to view this content.

Its actually leaving a blank row below the last row of data and then pasting it

It works fine at my end. Maybe you can attach your file if you are still facing issues.

[Statesman]

Hi Arlette,

Thanks for the input. It just pastes the row for sheet1 into the same row in sheet2 rather than the next one down (so it compiles a list). I've attached my file. Thank you.

[arlu1201]

Since your data starts in column B, change this line from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Statesman]

Thank you so much for your time helping me with this. I made the amendment but now the debugger runs in that line?...

[arlu1201]

What error do you get?

[Statesman]

Run-time error 1004 "the information cannot be pasted because the copy area and the paste area are not the same size and shape..."

[arlu1201]

Change this code from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Statesman]

Thank you... Now it's copying it and deleting from sheet1 as it did before but not pasting into sheet2?? I'm thinking of selling my laptop and buying a cat, although that probably won't do as its told either lol

[arlu1201]

Add this line to clearcontents -

Please Login or Register  to view this content.

[Statesman]

Thanks heaps, that fixed that; but still have the issue with it only pasting in row 3 and not compiling a list (ie row 3 then 4 then 5 etc)in sheet2. Is it doing that okay at your end? I've wondered for a while if my office is buggy as have had macros work fine at work then bug out on my lap top...

[event21]

Hi -

Try

Please Login or Register  to view this content.

Regards,
Event

[Statesman]

Thank you Event the macro now runs perfectly. And thank you Arlette for your time too, I was able to sort another buggy macro aswell by using your suggestions (I'm very new to vba, obviously) the cat will have to wait now ... Thanks again. Adam.