This is a really specific problem I was hoping to get help with for a small school.
I have students, teachers and teacher planning worksheets and need to find a neat and dynamic solution to the following in the ‘Scheduling’ table:
-
lookup teacher names – this i can do!
-
based on teacher name, dynamically bring up what they have previously planned in the activity column. Different teachers can teach the same topic taught by a previous teacher – only their planning notes might differ.
-
based on the student attendance register for the day, a dynamic list of students need to come up, but crucially, a teacher can select one or more student names to be in their activity.
-
at any given time, 3 activities take place. Based on Teacher 1 student selection, Teacher 2 cannot choose the same students selected by Teacher 1, and similaryl Teacher 3, can only select students who are present but not selected by the other teachers.
Hoping this all makes sense with the following screenshots:
I have tried a bunch of xlookups. My real problem is how to append student names to a single cell (in different lines) based on teacher selection.
I really don’t want to use VBA as i just don;t have the knowledge for this.
AbsRa is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.