I have a very large spreadsheet that records pupils levels.
As they pass each level, the teacher can check off which one they have just completed and the levels pop up next to their name.
Because this system will be used throughout the school, there are 125 different levels for every child.
I have checkboxes set up, but I was wondering if there was a way to create a button so that when you press it, it will check off the next consecutive checkbox, instead of having to hunt through all the levels to check off the next one.
So it would begin with checkbox1, and then if you pressed the button it would check checkbox2, then checkbox3 and so on.
My macro skills are not brilliant and I'm not sure if this is possible. Any help or suggestions would be greatly appreciated
Thanks
Bookmarks