Hope I'm in the right forum...

What I'd ultimately try to do is to have a link between sheets but with
different data being propagated. Such as:

Sheet "A" is the schedule sheet with employee names listed. Let's say
Employee "1" is listed in cell A1 and I input 9:30 AM in cell B1 (i.e.,
Employee "1" scheduled for 9:30).

Sheet "B" is a list of the schedule times. If 9:30AM is in cell A4, is there
a way to automatically propagate "Employee 1" into B4 when "9:30 AM" is input
to B1 on Sheet "A"?

I suppose the formula I'm looking for is something like:
=if(sheet1!B1="Employee 1")="Employee 1"

Thanks (I think I'm moving into "Access" here)
--
6-West

--
6-West