I have two spreadsheets that are showing student results on templates, 09Sci and 10Sci. Both sheets have been set up in an identical fashion (I copied and renamed the 09Sci to create the 10Sci). The only real difference was the 10Sci had additional assessment results added to it.
When I choose a student name from the dropdown list on the Student_Profile worksheet it performs as expected. However, if I use the buttons to go first, last, previous or next, the student name in cell J3 (SurnameSel) is not updating to the currently selected student.
I'm baffled and not sure where the problem lies. Everything seems to be in order and I haven't changed any code apart from adding the extra assessment item.
I've attached the 10Sci spreadsheet which is not updating the current student's name in cell J3 and the 09Sci which is working as expected.
Any help would be greatly appreciated.
Thank you.
PS. I'm using Excel for Mac 2011 but I also tried it on a PC with no luck.
Bookmarks