Just some ruminations on:
.. As I fill in my schedule with start times I want it
to place the names in the corresponding time slot on the floorplan ..

Try this sample from my archives for some relevant ideas:
http://savefile.com/files/933196
Workstation Scheduling 24hr x 36 seats x 100 staff.xls

And think it's always simpler to frame it all up & get it working within
sheets in the same book.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"RaY" wrote:
I have two workbooks, Schedule(in military time) and another Floorplans(days
on different worksheets). As I fill in my schedule with start times I want it
to place the names in the corresponding time slot on the floorplan. My
schedule has up to 5 people with the same range however 2-4 people may have
the same start time for a single day. If I have Friday in Column C and the
times from C2:C40 can I get excel to plug those into the Floorplan with a
formula that can deal with the duplicate times?