Let me explain the problem.
1st sheet contains a list of legal court case numbers and their
details.
The following sheets contain the court hearing dates of these court
cases, one worksheet corresponding to one month. Each month the dates
for a particular case may come more than once.
I need to prepare a report which shows all the court cases alongwith
their latest date of hearing taken automatically from the various
monthly worksheets.

Hope that explains the problem. Thanks for taking interest in the
problem.


--
brshm
------------------------------------------------------------------------
brshm's Profile: http://www.excelforum.com/member.php...o&userid=23509
View this thread: http://www.excelforum.com/showthread...hreadid=372174