I have a list of speakers (speakers sheet) on a worksheet, each speake
has checked timeshots when they are available to speak. There are onl
3 time slots per day : 1. 8-12, 2. 12-5, and 3. 5-12 mid.
Sample Record on Speakers Sheet:
("|" = column separator)
Headers:
Nam
|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 workshee
(assignment sheet) for recordining speaking requests, and th
assignment worksheet display a filtered list (from the main list) o
who is available?
Thanks for any advice you can offer
--
JanetFan9575
-----------------------------------------------------------------------
JanetFan95758's Profile:
http://www.excelforum.com/member.php...fo&userid=2344
View this thread:
http://www.excelforum.com/showthread.php?threadid=46909