Need help in creating macro


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question