I do the rotas/schedule for volunteers at my church. Is it possible for excel to allocate volunteers to a rota whilst taking into account the days they are not available? Each rota has a list of names of volunteers prepared to be on the rota. Before the rota is completed we ask them to tell us the dates they can not help; then the names are allocated to the rota as fairly as possible making sure they are not rostered on a day they are unavailable. Then the rota is published paper format. I made, what i thought would be a helpful, start to a spreadsheet but can not find a way to easily take into account the days people are not available. Help with amending the sheet very welcome alternatively examples of how others have achieved similar.
