+ Reply to Thread
Results 1 to 8 of 8

Overtime Rotating Seniority list.

  1. #1
    Registered User
    Join Date
    09-29-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Overtime Rotating Seniority list.

    Hi Everyone, Im new here and could greatly use your help.

    I am trying to create an overtime staff listing based upon the seniority of those staff.

    I already have the list sorted from A1:A50 with the names of staff based on seniority date.

    My goal for this list is to have it rotate based upon seniority date, i.e. If Staff in A1(highest seniority) picks up a shift, the next day their name would be located in A50.

    I am thinking it is best to do this on a weekly basis so Im assuming I will need a column of names for day 1, and then a numeric value to signify they picked up a shift say in column B. Therefore im assuming I would need a total of 14 columns to accomplish what I am looking for.

    The main thing I am struggling with, and I dont know if this is even possible, is to have excel automatically sort the next days list of names in Column C, E, G, etc for the next days based upon whether or not they had picked up shifts on the previous days.

    Please let me know if you need any additional clarification or information on what kind of a list Im trying to create.

    If you have any alternative ways in which i can accomplish this rotating list please let me know.

    Thank you in advance!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Overtime Rotating Seniority list.

    Welcome to the forum.

    Post a sanitized workbook with an example.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-29-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Overtime Rotating Seniority list.

    Hello shg,

    Is this what you were looking for. If so, ignore the subs part at the bottom of the list. Please let me know if it is not. Thank you !
    Attached Files Attached Files

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Overtime Rotating Seniority list.

    Why not just sort the list by seniority and put assignment dates in the adjacent column?

  5. #5
    Registered User
    Join Date
    09-29-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Overtime Rotating Seniority list.

    this may sound confusing but might bring to light why i want it to be a rotating list.

    This list is for overtime hours and available shifts/overtime hours fluctuate daily. Some days we may need 5 people, some days we may not need anyone. So i need a running/rotating list that changes daily so that every staff is given overtime equally. Secondly, the staff have the option to sign up for the shifts they want to pick up, so there are never any set times, and its up to us to assign them first based on seniority. After they have picked up one shift, they are not at the bottom of the seniority list.

    I forgot to mention this before but I want to use this as a tracking tool rather than something that the actual staff would look at for their assignment.

    I hope that helps describing more of what I am looking to do.

    Thanks again!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Overtime Rotating Seniority list.

    I get the idea, but I don't know what you want the result to look like.

    You have a list of people and their seniority; then someplace else you have a list of dates, and the people that worked OT on those dates? And below that, you want everyone's name to appear in rotation, with the least (or most) senior person on deck for the next OT shift?

    I'm making this up as I go along, but you're the person that needs to figure out what they want.

  7. #7
    Registered User
    Join Date
    11-30-2011
    Location
    Minnesota, USA
    MS-Off Ver
    Excell 2007
    Posts
    6

    Re: Overtime Rotating Seniority list.

    Did you every find a solution?

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Overtime Rotating Seniority list.

    Lonadawn,

    This is an old thread and you are not likely to get a solution.

    Why dont you create a fresh thread? You should get faster solutions this way.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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