Hi, I currently produce my nursing rota using excel, whereby the weeks
shifts for all the staff are produced on a couple of A4 printouts. We
then take this information and transcribe into a diary those staff
working an Early, Late or night on the Monday of that week, then the
Tuesday and so on. My problem however is that my staff make
transcribing errors so that when staff check the diary to see who is
supposed to be working it is often wrong. What I would like to do is
have 7 additional worksheets each labelled Monday, Tuesday etc and for
those staff working an early (E), Late (L) or night (N) to
automatically be entered on the correct worksheet for the Monday,
Tuesday etc.

I currently have staff names in column B row 22 to row 52 and the
shifts they are to work in columns E (Mon) F (Tue), G (Wed), H (Thurs),
I (Fri) J (Sat) K (Sun), there shifts are either an E (early), L
(late), LD (longday) or N (night), I then have the 7 worksheets named
Mon, Tue etc with row labels of early, late or night, with entry rows
below each label to transcribe those on a early, late or night, how can
I transcribe those staff working an early on Monday into the row on
worksheet Monday etc?

Any help would be appreciated,

Sandy Lay