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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look Up Available Speakers
Why use another sheet?
Put an autofilter in the timeslots row (above the list of speakers) then by choosing the appropriate time slot column set the filter to =1. The list will show ALL rows available. You can copy the filtered list to another sheet if you wish. -- Cheers Nigel "JanetFan95758" wrote in message news:JanetFan95758.1vngyc_1127207162.4267@excelfor um-nospam.com... 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. -- JanetFan95758 ------------------------------------------------------------------------ JanetFan95758's Profile: http://www.excelforum.com/member.php...o&userid=23449 View this thread: http://www.excelforum.com/showthread...hreadid=469099 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look Up Available Speakers
It is because the sheet contains MANY more columns than the ones defined in the question (trying to keep my question simple). An several of those columns would be very much in the way. Therefore, was hoping to use automation to either copy the rows with columns tha contain needed details that match the criteria, or create a linke section in some way....but again I need guidance. Sorry, I can't put it all on one sheet -- JanetFan9575 ----------------------------------------------------------------------- JanetFan95758's Profile: http://www.excelforum.com/member.php...fo&userid=2344 View this thread: http://www.excelforum.com/showthread.php?threadid=46909 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How BEEP on internal speakers, not on sound-card? | Excel Programming |