Copy/Paste user input info into another worksheet

[MarkExcelMark]

Hi all --

In sheet one when user enters value (a questionnaire) and hits the "Save" button: 1. It should copy the values entered and pastes its horizontally so as to create a table in Sheet 2.

2. Then it should clear the answers for the next set of input values. And again when the Save button is hit, it should copy/paste it to the next line in Sheet 2.

I was able to record a macro to copy/paste to the next sheet. But how do I get the next set of values to be copy/paste to next line in Sheet 2, instead of it overwriting the initial info?

Here's what I have:

Please Login or Register  to view this content.

Thanks,

Mark.

[jaslake]

Hi Mark

I've taken the liberty to "clean up" the macro recorder code to eliminate the "selects" you get with the recorder. You don't often need to "select" to perform an action on a cell.

Read the code...if you need clarification...let me know.

Please Login or Register  to view this content.