I am trying to create a program that I can used to build student schedules on that will automatically give me names of students in each of a teacher's classes. For example, I can build a schedule for John Smith. John Smith is in Math 1st period, Science 2nd, History 3rd, etc. I want to have a separate sheet for each teacher, and based upon the main sheet of students, each student would show up in each class. I have already built the program for the most part, with the first student in that class's name. The problem I am having is retrieving the rest of the names on the list.

I will attach my file in-case there is anyone out there who wants to take a stab at it.

2015-2016 High School Schedule.xlsx

Much appreciated!