asherlevin
New Member
- Joined
- Oct 7, 2017
- Messages
- 9
Here is Sheet 1.
This is a student grade book. If a student has an x under a topic, that means they have achieved that goal.
Test has therefore achieved 'Recognise the use of binary numbers...' etc.
Here is sheet 2.
When a student types their name: 'Test' in this example -> I want the next cell goal which doesn't have an X next to it, to appear on this sheet where it says 'Next Goal'.
So the next goal, on sheet 1' is: use binary in computer registers...etc.. When I type in X on sheet 1, it will then jump to the next goal for Test.

This is a student grade book. If a student has an x under a topic, that means they have achieved that goal.
Test has therefore achieved 'Recognise the use of binary numbers...' etc.
Here is sheet 2.

When a student types their name: 'Test' in this example -> I want the next cell goal which doesn't have an X next to it, to appear on this sheet where it says 'Next Goal'.
So the next goal, on sheet 1' is: use binary in computer registers...etc.. When I type in X on sheet 1, it will then jump to the next goal for Test.