Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look Up Available Speakers
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How BEEP on internal speakers, not on sound-card? | Excel Programming |