Hi Scott

is this just for printing out? if so i would use the autofilter (data /
filter / autofilter) - choose the drop down for MONDAY, choose AM print
results ... choose PM, print results ....

Cheers
JulieD

"Scott Cheesman" <Scott wrote in message
...
I've got a basic rota sheet with Mon-Sunday along the top and the names of
the staff down the side.

Each day a memember of staff is either AM, PM or OFF.

I'me trying to create a sheet that just has monday at the top with all th
AM
people on it. Then a sheet with all the PM people on it.

Any idea's?

Thanks in advance

Scott.