I
Igneshwara reddy
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.
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.