Please refer attachment. In the header row(A), amongst other, the dates
of the month appear. In the "Date Complete" column, I want the date
under which the status was changed to "Passed" to automatically appear
in this cell.


+-------------------------------------------------------------------+
|Filename: Batch Status Report.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=5038 |
+-------------------------------------------------------------------+

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