My Christmas Grotto Staff Roster Needs the Help of an Excel Expert...

[wisematthew]

Dear Excel Community,

I run an events company operating Christmas grottos throughout the UK. Key to what we do is the rostering of staff.

I have an Excel template ('Example Roster 2013' attached), into which on the first tab I put the opening hours of grottos and it will populate the correct shift patterns for Santa and his Elves.

We then manually input the initials of the employees who will cover each shift resulting in a roster which tells us who is working and when.

What is does not do is allow me to automatically generate individual hours sheets for each staff member based on where their initials appear in each time slot. Currently, we are manually creating these sheets by reading the initials off each time slot and inputting the shift into a ('Staff Member Hours Template.xls' attached).

The tab marked WK34 is filled out as an example.

Can anyone create a automatic process for me?

Kind regards,
Matthew

[wisematthew]

Happy to pay someone for this job...

Matthew

[WasWodge]

Cross-posted here

If you must X-Post...Why you should post a link
The Forum Rules

[alansidman]

If you are looking to pay for a solution, then perhaps you may wish to post this in the Commercial Forum on this site. If that is your wish, please advise and I will close this post and you can then re-post in the commercial forum.