Hi Guys
I'm new here and very new to Excel so apologies in advance for being a newbie and a novice!
I have been trying to create a couple of spreadsheets to help save me time and manage my small team. I have been successful on creating a working spreadsheet but on this one I need some assistance as not too sure where to start creating formulas.
I need to create a staff timetable so at a glance I can see quickly who is in on what day - so I will have a table for each day with the staff names and then I would like the times to be shaded with a colour if they are in... if that makes sense?
I have been given a template from a friend which was a help but has no formulas I have attached it for you guys to see and hopefully then this will make more sense...
So, there 2 shift patterns a Week A then a Week B I have created a tab for each week. I have then created a tab for the Rota where I will enter the hours that the staff member will be doing in Week A and Week B and I would then like it to shade on the Week A/B tabs in the colour depending on their task, is this possible? I know I may have to alter the spreadsheet possible but I have no idea what I will need to change or how to write the formula needed,
Any help will be appreciated and many thanks in advance. If this is the wrong forum for asking for help like this please say.
Thanks
Freddy.
Bookmarks