I'm looking for a look-up solution for a worksheet.

My worksheet column 68 contains dates. I need to figure out how t
code the following scenario:

The end user enters a date into an input box:
dtReportDate = (Date:=strReportDate).

I want to display ALL matching dates in another worksheet("To Do List"
to create a report. Im assuming I will need some kind of a Loo
Statement or For Each statement.

Can anyone help me out?

Thanks

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27714