I created a work schedule on excel. Along the top I have a cell labeled with numbers corresponding to the days of the month. Along the left is a list of employees. I fill in cells with letters corresponding to days off, vacation, personal days, training, etc... What I have left are a bunch of blank cells corresponding to days employees are scheduled to work. This is the part I need help with. Now for every day I have to go down the column and manually type in a number from 1-7 (in the blank cells)which tells the employees what area they are assigned to work in. Any extra people that are working then get assigned to areas 8-12. Is there a way to auto fill the blank cells with the numbers 1-7 randomly in each column and then 8-12 for any extra blank cells in the column? I have to use 1-7 once per day and then 8-12 once per day for any remaining cells in the column.
Thank you in advance.....