Aussiegirlone;329601 Wrote:
It goes like this.
The roster is made up for the entire day of each employee for the total
week. However if one employee decides not to show up [with only an hours
notice] then the roster has to be change so that someone can replace
that employee as they are all on call at a moments notice.

Your comment: No way to determine the last entry/change

My reply
Once the week has ended all data entered will not be changed for the
week ended however, the week must end with all jobs completed.

If the week has not ended then changes should be able to be made.

As for the times there will be no AM or PM

Also here is the revised Roster. Can you tell me how to delete the
other roster please?:)
Just looking at your revised workbook i see the SITE sheet is now
dated in single days yet 7 days across the columns and you no longer are
looking at "Week1", "Week2"...etc, can you tell me what its is you
really want to see and do?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91647