Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ref Info Tables
Hello All,
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 | |||
Where would be a good place to get info for pivet tables | New Users to Excel | |||
Charts and data tables different info | Charts and Charting in Excel | |||
Retrieving info from multiple tables | Excel Discussion (Misc queries) | |||
Extracting info to new tables | Excel Discussion (Misc queries) | |||
Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions |