Apps Script to build Teacher roster sheets from a master list of all students

‪@redtailfanschool‬ In this video we demonstrate how to build a sheet and apps script that will take a list of teachers, and a list of teachers and students and build a new sheet for each teacher with their student information on it We can then use this master sheet to import the student roster data to other individual teacher sheets for other uses.
The script inserts a new sheet for each teacher name, adds the teacher name to cell A1 of the new sheet, and sets a QUERY formula in cell A2 of the new teacher sheet to pull in that teacher's student list.
Make a copy of this sheet to see how it works and get the scripts.
docs.google.co...

[@ekelly858]

This is awesome. Thank you!

[@redtailfanschool]

Glad you liked it!