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