Export entered values into a different sheet by pressing a button

Hi,

I have the following excel file where I ask respondents to enter some scores in one tab and I want to create a button that export the values entered into a different tab.

The values entered are in the Home sheet C5:C15 and I want to export them to the Model sheet H5:H12. Please note that the order of the values is different in the Model sheet.

I, also, would like to create one condition. Respondents must answer all questions before exporting the scores.

Thanks for your help!!!

Please, note that I have a Reset Scores' button. I already know how to do this :-).

example drop down list.xlsx

Try the code below:

Please Login or Register  to view this content.