I am trying to build a macro for an answer sheet in such a way that, it
performs the below functions when I click on the €œSUBMIT€� . The sheet
contains two tabs. Firs tab is questions along with the answer options; like

Question # Answer

1 Yes
2 Yes
3 No
4 No
5 Yes
6 Yes
7 No
8 Yes
9 Yes
10 Yes


It should prompt for the USER ID in the question paper sheet

The answers should be copied to the second tab and have to be pasted in the
sheet (the data will be in columns and it has to be transposed to rows) along
with the user ID


Ex: USERID Answers from 1 €“ 10

The same sheet will be used by several people and it has to be shared. Each
time the user clicks on submit button, the USER ID and the answers from 1 €“
10 have to be passed in a single row in the second tab and then the answers
have to be validated with the master sheet which would be in the third tab.

Note: The number of questions may change from time to time and has to be
compatible to adjust with the numbers.

In two columns, I would name as total marks and Percentage. It should
calculate the score and also the percentage and should show up immediately
after clicking on the SUBMIT button and also have to be stored in the path I
mention it.

Kindly let me know how I can do this.