Trying to create an on call rota with specific funtions and need a clue or two

Hi,

I have been asked to create an on call rota for my work and need some help.

Basically I have 11 members of staff of which 2 members of staff go on call each night 7 days a week.

I am trying to create a rota in excel that creates this for me and randomly allocates staff to the rota also have a separate column in the rota for holidays that the main rota refers to so that it does not allocate those members of staff to those dates on the rota if they are on annual leave. Also staff can only do 2 in 4 weekends each.

I have attached my very basic idea of how it should look and really don't know where to start.

Anyone fancy a challenge?... if its even possible lol

Thanks for any help in advance

you can use my sheet for my question ( http://www.excelforum.com/excel-gene...ease-help.html) ; mine is not where i want it but it should do what you want.
you wont be able to lock out certain days (requested days, etc) but it will do what you are asking.