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

This sounds like a question for the programming newsgroup
NOTE: do not put Re in subject line since this makes your message look like
an answer rather than a question

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"brshm" wrote in message
...

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