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