Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Ref Tables
I don't know if I'm asking the impossible here but I'll give it a try. I have a excel program which I am trying to set up a function whereby it will create a work rota based on a shift pattern. It currently will create a table with staff names on it and there shift pattern for a given week. What I am trying to do is let the user select shift pattern 1 for example and have excel transfer this onto the rota but place the name instead of shift in the appropriate shift. ie If I select shift 1 it will place name A onto the early shift and place A on the Day off line which in this case is Friday.The actual rota has 14 staff on it per day, seven days a week. Some are early, some back and some off. I hope I have explained it clearly but knowing me probably not. Thanks for taking the time to look at it Colin Name Shift Sun Mon Tues Wed Thur Frid Sat 1 A E E E E Off E E 2 B B B B Off B B B Early Shift 1 A A A A A A Back Shift 2 B B B B B B Day Off B A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) | |||
How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) | |||
compare tables | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) |