I have a list of speakers (speakers sheet) on a worksheet, each speaker has checked timeshots when they are available to speak. There are only 3 time slots per day : 1. 8-12, 2. 12-5, and 3. 5-12 mid.

Sample Record on Speakers Sheet:
("|" = column separator)
Headers:
Name |Mon8-12|Mon12-5|Mon5-12|Tues8-12|Tues12-5|Tues5-12|etc..Sun5-12
Sample Row:
Jane Doe | 1 | 1 | 1 | 0 | 0 | 1 | .... 0

1 Means they checked the time above, and 0 means they did not.

Here is my question: How can I enter a time on another worksheet (assignment sheet) for recordining speaking requests, and the assignment worksheet display a filtered list (from the main list) of who is available?



Thanks for any advice you can offer.