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

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

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