I currently have a userform with a button for the user to submit their input, which pastes it into a hidden worksheet. I am trying to have the macro paste in the first blank column in row 1 and then paste the remaining values going down the same column. My issue is that I can get it to paste in the first blank column, but it then continues inputting values across multiple columns rather than moving down the column across multiple rows. Below is the current code I am using related to the submit button. Any help would be greatly appreciated. 

Please Login or Register  to view this content.