OK I have an excel spread sheet that grades answers I have a macro that runs and puts the person with the most correct first and so on.
The last answer given is a bouns answer. The excel sheet is setup so that the persons name are in C2 to AI2. Answers are from C3 to C17 for the person in C2 and so on.
When I run the the "Correct Number" button C22-C27 are fill out.....The problem is I need the last entry in cells C2 to C17 to be in C27, the last entry can be any cell C2 to C17.
Attached please find an example of the excel sheet.
Thanks for your help
Dave
The last answer given is a bouns answer. The excel sheet is setup so that the persons name are in C2 to AI2. Answers are from C3 to C17 for the person in C2 and so on.
When I run the the "Correct Number" button C22-C27 are fill out.....The problem is I need the last entry in cells C2 to C17 to be in C27, the last entry can be any cell C2 to C17.
Attached please find an example of the excel sheet.
Thanks for your help
Dave