Thread: Pasting to next open row on different worksheet

Hi,

I have a spreadsheet with 2 worksheets. Worksheet ONE asks the user to enter certain info such as name, date, etc into specific cells. What I would like to do is once the user enters all the info, he will click a button that says SAVE or SUBMIT. Once this is done, I would like the information the user just entered to populate the next open row in Worksheet TWO and clear the cells in Worksheet ONE that were just filled out.


When the next user enters the info and clicks SUBMIT, his data would be copied directly below the previous user's data on Worksheet TWO.

I hope this makes sense.

I'm by no means an expert in Excel, but am fairly proficient and do know a little about Macros and Modules and all that good stuff.

Thanks for your help!
Mike