I have a crew schedule made up in excel. There are 4 different shifts A B C or D. There are 5 people on the schedule, and the schedule is laid out like this in excel:
Each person works the same schedule weekly, so it always looks like this for each given weekday.
I have figured out how to make the dates run consecutively in column A based upon the date entered manually in cell A4, and the day of the week in column B be based off the date to the left of that box in column A; all of that works great, and I made a separate spreadsheet for leap years.
My Question is this: Is there a way to make each person's shift be automatically entered in columns C through G based on the day of the week in column B in the row?
I currently have to manually type out everything in columns C through G and it is time consuming to say the least. My ultimate goal is when I input the date in A4 everything else will update automatically.