+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    10-24-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

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

    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
    Attached Files Attached Files
    Last edited by wisematthew; 09-21-2013 at 02:54 AM.

  2. #2
    Registered User
    Join Date
    10-24-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

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

    Happy to pay someone for this job...

    Matthew

  3. #3
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    881

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

    Cross-posted here

    If you must X-Post...Why you should post a link
    The Forum Rules
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

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

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting For Staff Roster - Enhanced
    By nancyching1711 in forum Excel General
    Replies: 3
    Last Post: 07-21-2012, 12:49 PM
  2. Conditional Formatting For Staff Roster
    By nancyching1711 in forum Excel General
    Replies: 13
    Last Post: 07-16-2012, 11:26 AM
  3. [SOLVED] Staff Roster
    By BlueHuman in forum Excel General
    Replies: 3
    Last Post: 03-28-2012, 05:09 AM
  4. Roster / Staff Allocation
    By KingAaron in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-13-2006, 09:40 PM
  5. I need a simple staff roster
    By Delma McDonald in forum Excel General
    Replies: 3
    Last Post: 03-09-2006, 03:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1