You are a legend! This is fantastic. Thanks so much for your help with this. I will be sure to credit you to my exams officer when I show her. I also like your suggestion for the color coding, I assume I can do this using conditional formatting on the cells?

Thanks again for your help

Kind regards
John