rota compile

[Guest]

Hi
I have a 5 week rota which displays a 4 week pay period's duties. The second
table shows who is covering which duty on any particular day. What I would
like to do is to be able to enter a w/c date which would then populate the
2nd sheet from the ist ignoring people who are resting. Any help would
gratefully received

 

[Pete_UK]

I think you will need to give a bit more detail regarding how your
sheets are laid out - what data you have in which columns, how many
rows etc.

Pete