I have a sheet that lists the duty roster for teachers. The row headers contain the date of the teacher's duty, and the column headers contain the time segments (9:00 to 9:30, 9:30 to 10:00, etc).
The teacher's name is in the cell intersecting the date and time segment. A teacher's name will appear in multiple rows, at potentially different time segments.
I would like to write a script that will search for a specific teacher and return a list showing all the dates, and the time segment for that date to which the teacher has assigned duty.
I appreciate any and all help. Thank you.

Aucun commentaire:
Enregistrer un commentaire