ref 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 |
All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com