Good Afternoon,
I am after some help creating a Rota generator for my office. Most of the time the staff work to set shift patterns, but because I've been instructed to provide a visual view to make sure all there areas are covered I have to keep the view that has been given to me.
What I am after is in the shift column there is a drop down allowing someone to select the shift required. Once the shift is selected, I want the cells to the right (Time Fields) to get filled with something for the Conditional Formatting to colour it in. There are some extra calculations that will be made in the form that will use the information populated which is why I need to use this format.
In the example is a sheet called 'Rota' which is blank, and another called 'What I would like' as an example.
If any help could be provided that would be great. I have had a lot of success in the past here when I cant work something out.
Thanks
Sam
Bookmarks