Copy specific range from one sheet and paste to next available row of different sheet

Hello koklok,

Here is the code...

Please Login or Register  to view this content.

Sincerely,
Lieth Ross

Leith, unfortunately it's not working and I don't know what needs to be fixed.

I'm attaching an example and more details if that helps.

Thanks

Hello koklok,

This macro will paste only the values from the Range("A3:H6") on "Step 1" to the next empty row on "Step 2". Copy this code and paste it into a VBA module in your project.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith,

Thanks for your help but there seems to be a small glitch.
When range A3:H6 is pasted to sheet(step2), my last row has underscore in the last row and that's good, but when I run a macro for the 2nd time range pastes over the underscore.
So the bottom line is that every time I run a macro it pastes over the last row of previous macro.

I appreciate your help

Thanks

Hello koklok,

This should fix the problem...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Unfortunately it's still not working

Hello koklok,

When I run the macro below, the underscore is copied. Can you be more specific about the problem?

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Ok, Leith

I see you made a little change and it's working now I appreciate your help.

Thanks

Hello sam_1981, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

When you start your own thread please use code tags on your code - click Forum Rules button @ top of page to see instructions in rule #3.