Quote Originally Posted by cantosh View Post
Take a look at the attached workbook and see if does the trick. You'll need to set calculations to manual or else the random word will keep switching. Because of the manual calculations, the only way to get an immediate response to your answer was to color-code it using conditional formatting. Put your 'Kup' number in B2, hit F9 to get a new word in A4, then type your answer in B4. If it's correct, B4 should turn green.
Note: your sheet for Kup 10 had an invisible space in the sheet name - " Kup 10" - that I fixed so it was consistent with the other sheet names
Yes that's almost what I am after. But is it possible to drop down a line each time until all the words are used up on page one, from all the words entered in the"kup" page?
Ie:- If there are 70 words in "kup 8", on page one it will drop down 70 times, and tell me that I got 36 correct, and 34 wrong on that particular grading.
That way I can see all the words that I am getting wrong and practice those more. I can also add a count cell at the bottom to show me how many I have got right or wrong. But thank you so far for your help.
Mark