Button macro to copy and paste a range

[Iamalazyemployee]

Hello everyone,

This is going to be a straightforward question, however I lack the excel knowledge to complete it myself. So I've got a range, the user populates it, presses the submit button, and I need help coding that button to copy the filled range and pasting it into the next open slot in the table. I've created a simply if statement so that the next available row in the table has a 1 in an off-column. So basically, I need help writing the code that takes the filled in column, and pastes it in the corresponding table column matching the 1 in a column of zeros.

Thank you for reading this, and thank you to those who take the time to respond,
A lazy employee

 

[Iamalazyemployee]

Sorry, I am trying to copy a range (row) into a row, that has a [1] next to it, I don't know why I typed column everywhere.

 

[HackSlash]

Post your code