Hello,

I have created an excel form that people fill in, click on a button which sends a mail of their form to their manager and then the form is refreshed to go blank.

The data that is input into this form needs to go to another sheet in the same workbook which acts as a database that keeps compiling data from the form. My problem when I use the value paste macro is that when the form is refreshed and someone new comes in to fill the form, old data from the database disappears while the new entry stays even after refreshing.

Any suggestions ?