Martin,
Appreciate your quick response. May'be I must elaborate. The workbook
contains a spreadsheet for each month of the year and each spreadsheet
each date for the indivudual months. The "Passed" status can appear
under any of the dates for the months. The status is changed in the
individual cells based on the current status for a specific date.


--
Hennie
------------------------------------------------------------------------
Hennie's Profile: http://www.excelforum.com/member.php...nfo&userid=399
View this thread: http://www.excelforum.com/showthread...hreadid=561829