Scheduling Advice

[arityker]

Hi everyone,

I'm trying to make a scheduling template through Excel and was wondering if anyone could provide some advice as to how to go about this. For some context, I am scheduling teams of 3 on 2 shifts per day, everyday. Availabilities for the month are sent in through excel. I was envisioning something where I would paste the availabilities into different sheets of the scheduling template, and on the template sheet I would be able to make a drop down menu of everyone who made themselves available for that shift. Any help would be greatly appreciated!

Thanks