Hi gurus !
I would like to create a sheet that auto populates staff breaks in a working day.
I have 2 choices for breaks on an early shift, 2 choices for breaks on a late shift, and 2 choices for breaks on a night shift.
I have a table that shows each person's name and their preferred choices for each shift.
I am hoping that in a new table I can select if its an early, late or night shift, and then using data validation select a list of names that are working. Then a magic button or something that will look at the preferred times for each person working, and populate their break time with one of their choices.
Obviously I do not want everyone to have the same break so need to factor in a max number of times a break can be allocated depending on the day in question!
It sounds complicated to me but hopingnits not, as will save soo much time every day trying to work it all out.
The staff working any one shift change regularly so it's not like I can create a template were I to have the same team every day. There are 25-50 people I need to allocate breaks to each day!!!
Thanks in advance. Rob
I would like to create a sheet that auto populates staff breaks in a working day.
I have 2 choices for breaks on an early shift, 2 choices for breaks on a late shift, and 2 choices for breaks on a night shift.
I have a table that shows each person's name and their preferred choices for each shift.
I am hoping that in a new table I can select if its an early, late or night shift, and then using data validation select a list of names that are working. Then a magic button or something that will look at the preferred times for each person working, and populate their break time with one of their choices.
Obviously I do not want everyone to have the same break so need to factor in a max number of times a break can be allocated depending on the day in question!
It sounds complicated to me but hopingnits not, as will save soo much time every day trying to work it all out.
The staff working any one shift change regularly so it's not like I can create a template were I to have the same team every day. There are 25-50 people I need to allocate breaks to each day!!!
Thanks in advance. Rob