I am trying to use excel to schedule
mechanics for saturday.
I have groups like brake, lube etc.
each groups may have 2-5 mechanics.
For every Saturday, the list should pick one mechanic from each group.
next Saturday it should pick second mechanic.

IS it possible to do it in excel ?

Thanks much

vikkam