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

One way to make it easier is to stick with the original table, and once
the data is entered:

sort the table on the Monday column, for example,
add sub-totals (data, sub-totals), which will group the data on the
sorted column, with a line for the value followed by one row for each
staff member in that group.

then print the column of staff names, including Monday.

then remove the sub-totals (Data, sub-totals, Remove all), and repeat
for the next column.

You can do this for each day of the week, and if required, hide the
columns you don't want to see before you print each result.

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=564038

Hi,

Not great on VBA but the attached works for me

Need a expert to tidy up code.

http://cjoint.com/?hxjEVLJo1v


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564038