Data Between Workbooks

  • Thread starter Thread starter RaY
  • Start date Start date
R

RaY

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 ..
Click to expand...

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
---
 
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.
 
fyi- The floorPlan can have between 3-16 of the format shown below and each
seperated by one space.
 
Back
Top