hi folks, i am working on a course selection workbook and have run into an issue. I have listed the course's core subjects at the top of the tab and these are marked off ( a 1 is placed next to the subject name) when the student completes each subject. in one term, they get to choose four electives from 6 choices. In the Core Subjects table, the four electives are listed as Elective 1, 2, 3, & 4, not by subject name. The six choices are in a separate box below the core subjects. when these electives are completed, a mark (a 1) will be placed next to the particular subject. Once a student has completed their first elective, how do i get the mark the mark (a 1) to appear in the Core Subjects table next to Elective 1, and then also for their second, third, and fourth choices?
So if a student completed Elective B, we would place a 1 adjacent to B in the Electives table. How do i get this to show up adjacent to Elective 1 in the Core Subjects table above? I was thinking of a sequential lookup but that requires the lookup value to be common to both tables.
So if a student completed Elective B, we would place a 1 adjacent to B in the Electives table. How do i get this to show up adjacent to Elective 1 in the Core Subjects table above? I was thinking of a sequential lookup but that requires the lookup value to be common to both tables.