I have a worksheet that we are using as a scheduling board. A list of
our resident rooms is in the first column (1-49). Next to that is a
section for our 3 therapy disciplines (PT,OT,SLP). Each of these 3
sections has a column for employee initials, a column for time and a
column that is either left blank or has a 't'. The list basically
indicates for each room what time a particular therapist is scheduled
to see that resident. The 't' indicates that the staff needs to have
that resident ready to be transported to our gym.

I would like to create another sheet for our transport staff that would
only show a list of Time/Room#/Staff Initials for residents that have
ben identified for transport. Right now we are just typing out a
seperate list of everyone that has a 't' and then sorting by time..
but I am pretty sure excel is able to look at a column (or 3 in this
case) and for every cell that it specifically finds a 't' add the
adjacent information to a seperate sheet and sort it by time.

I just am at a loss of how to do this.

Any help is greatly appreciated.

Matt