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?

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?

From the looks of it I think I can apply it to my setup.
Thank you.

"Max" wrote:

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?

Welcome, glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik
---
"RaY" wrote in message
...
From the looks of it I think I can apply it to my setup.
Thank you.

I took your advice and copied the schedule to a new sheet within the same
workbook as my floorplans. I been playing with it and I'm struggling a bit.
I'll give you the layout I'm trying to apply some of your formulas.
(Schedule)
(Name) (Day/Time) (Day/Time)
B C D
Friday Saturday
Kyle Doe 1200 1530
Sue Doe 1200 1430
Peter Doe 1530 1830

FloorPlan has tabs for each day of the week.
(In) (Name) (Out/Zone)
D E F
1200 (Name Here) GU
Lunch 1420-1500
20min 1740-1800 2030

I seen your templet used a column and a row to place the Name. I'm having
trouble applying that to this. If you need more information let me know.
Thank you.
"Max" wrote:

Welcome, glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik
---
"RaY" wrote in message
...
From the looks of it I think I can apply it to my setup.
Thank you.

fyi- The floorPlan can have between 3-16 of the format shown below and each
seperated by one space.

"RaY" wrote:

I took your advice and copied the schedule to a new sheet within the same
workbook as my floorplans. I been playing with it and I'm struggling a bit.
I'll give you the layout I'm trying to apply some of your formulas.
(Schedule)
(Name) (Day/Time) (Day/Time)
B C D
Friday Saturday
Kyle Doe 1200 1530
Sue Doe 1200 1430
Peter Doe 1530 1830

FloorPlan has tabs for each day of the week.
(In) (Name) (Out/Zone)
D E F
1200 (Name Here) GU
Lunch 1420-1500
20min 1740-1800 2030

I seen your templet used a column and a row to place the Name. I'm having
trouble applying that to this. If you need more information let me know.
Thank you.
"Max" wrote:

Welcome, glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik
---
"RaY" wrote in message
...
From the looks of it I think I can apply it to my setup.
Thank you.