HI i am trying to do this in a rota and struggle to get this working. my excell skills are not so good. would someone be able to help me out with that please? see the file atttached here...new rota.xls i would be most grateful.
the idea is that the 'assintnats names are being chosen from the drop down list in the am section and the pm section and once used within am section the wil disappear but still can be used in the pm section where the would disappear if they were used there.
then the Users would be used in the core members section in one of the six boxes in each row again the same as before in the AM and PM sections separately and would diaper in each section respectively from the drop down lists after being chosen.
this is way over my understanding of Excel but would make my life much easier....