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!
Bookmarks