| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Between Workbooks
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
Can you upload a sample file (in .xls format) using a free filehost,
then post a link to it here? For example, you could use this free filehost to upload: http://www.freefilehosting.net/ Copy the "direct link" which is generated after you upload, then paste it here (Desensitize your sample as appropriate) -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000, Files:358, Subscribers:55 xdemechanik --- "RaY" wrote in message ... 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
Idealy the names on the Schedule will have last names however only the first
name is placed on the FloorPlan. Here is what I have. http://freefilehosting.net/download/3l3ah "Max" wrote: Can you upload a sample file (in .xls format) using a free filehost, then post a link to it here? For example, you could use this free filehost to upload: http://www.freefilehosting.net/ Copy the "direct link" which is generated after you upload, then paste it here (Desensitize your sample as appropriate) -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000, Files:358, Subscribers:55 xdemechanik --- "RaY" wrote in message ... 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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
Ray,
Had a look. I'm sorry that your schedule, as-is, is too complex for me to automate. -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "RaY" wrote in message ... Idealy the names on the Schedule will have last names however only the first name is placed on the FloorPlan. Here is what I have. http://freefilehosting.net/download/3l3ah |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Between Workbooks
Thank you for looking. What you sent me has put me on the right track.
Ray "Max" wrote: Ray, Had a look. I'm sorry that your schedule, as-is, is too complex for me to automate. -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "RaY" wrote in message ... Idealy the names on the Schedule will have last names however only the first name is placed on the FloorPlan. Here is what I have. http://freefilehosting.net/download/3l3ah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
| Best way to import data from many several workbooks | Excel Discussion (Misc queries) | |||
| Copying data between workbooks? | Excel Discussion (Misc queries) | |||
| Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Linear Mode
