Copy/Paste Range to the bottom of a range on another worksheet using VBA

Hello All,

I'm trying to copy and paste a range on one worksheet to the first row below a range on another sheet. Here is the code I tried to use but I think I'm way off. I tried modifying several things I saw here on the sight but I lack the proper understanding of writing code.

Please Login or Register  to view this content.

I also attached an example workbook that shows how the end result should look.

Any help would be much appreciated.

Thanks Jeff. The actual spread sheet values were in the A column. I tried to alter it to get it to work but had more success modifying Norie code. Thank you very much though. I really do appreciate you taking the time to assist me.

Hey Norie, The code you provided based on the worksheet worked perfectly fine. Thank you very much for your help. Now on to the rest of this workbook.

Best Regards,

-Troy-