Autofilling or creating a dropdown menu for a monthly shift schedule

Your sheet does not provide much information to do things that you request, like there is no time.

Moving on, I prepared your calendar to react to the change of each month and year, also weekend. Feel free to play with it.

Originally Posted by DJunqueira

Your sheet does not provide much information to do things that you request, like there is no time.

Moving on, I prepared your calendar to react to the change of each month and year, also weekend. Feel free to play with it.

Well you are right, it doesn't provide the information since it was being done by hand.
I had to anonymize the sheet so i took some of the info out.
But basically there are 2 employees in the upper tier and 1 in the lower that are assigned for each tier.
I'll update with a small sample filling the required information in.
I updated it. So please feel free to ask if there are some things I haven't explained them right.
Thank you