A
Aaron
Hey all. Thanks in advance for any help. I am setting up a workbook to help simplify scheduling
classes for a school. I would like to look through a
column of classes, find a teacher's name, then copy the
information from that period to another sheet. I'm not
sure if this makes any sense, but basically, I'm trying to
create a system in which a principal can input a master
schedule, and the information automatically links to other
sheets to create teacher schedules.
here is part of a master schedule
600, 601, 602 are classes and 1, 2, etc. are periods of a day)
1 2 3 4
600 Science Spanish SS Math
Morris Bradley Dunn Finn
Rm.215 Rm.209 Rm.211 Rm.213
601 Science SS English Art
Humphreys oakes Bradley Roines
Rm.229 Rm.# Rm.211 Rm.207
602 Spanish Science SS Math
Frazier Humphreys Allen Alladice
Rm.221 Rm.229 Rm.208 Rm.214
Here is part of a teacher master schedule:
1 2 3 4
Humphreys
Bradley
Morris
--
classes for a school. I would like to look through a
column of classes, find a teacher's name, then copy the
information from that period to another sheet. I'm not
sure if this makes any sense, but basically, I'm trying to
create a system in which a principal can input a master
schedule, and the information automatically links to other
sheets to create teacher schedules.
here is part of a master schedule
600, 601, 602 are classes and 1, 2, etc. are periods of a day)1 2 3 4
600 Science Spanish SS Math
Morris Bradley Dunn Finn
Rm.215 Rm.209 Rm.211 Rm.213
601 Science SS English Art
Humphreys oakes Bradley Roines
Rm.229 Rm.# Rm.211 Rm.207
602 Spanish Science SS Math
Frazier Humphreys Allen Alladice
Rm.221 Rm.229 Rm.208 Rm.214
Here is part of a teacher master schedule:
1 2 3 4
Humphreys
Bradley
Morris
--