Each month we get a new rota made, with all of the staff team and different locations. There's nothing else that happens with the rota after it's been made, but I think that there are a few thing's that could be done with it, from automating some time sheet information, running a formula that would enable one to see just how many shift's a person has worked in a month etc.

It would also be good to be able to make a 'functional' rota from the information of this one. By functional I mean one that just had the information relevant to the actual day, and anyone who was off for that shift wouldn't show on the functional rota.

I'm not too sure what formula's are applicable for this type of thing.

The rota encompasses the whole company, but there are essentially 7 sections, representing different locations.

I think that this is probably a vague description and I'm sorry if Its no use, thought I'd ask though.

cheers