I'm having a hard time returning multiple dates from
worksheet("Customer Enrollment") column(68) to a seperate worksheet("T
Do List").

The User inputs the date he/she is looking for into an input bo
(strReportDate), later converted to "dtReportDate".

I WANT TO RETURN ALL OCCURANCES OF THE MATCHING DATE FROM COLUMN 68.
WHEN EACH MATCHING DATE IS RETURNED ID ALSO WANT TO INCLUDE TH
CORROSPONDING NAME FROM COLUMN 67 TO THE NEW WORKSHEET (TO DO LIST)

I can handle returning the name's, but Im not sure how to retur
multiple matching dates from column 68.



*Column 68 * (Dates from worksheet("Customer Enrollment")
-----------------------------------------------------------------------------------
10/23/2004 (these are date values in the spreadsheet)
10/25/2004
11/01/2004
11/01/2004
11/01/2004
11/02/2004
11/04/2004
11/04/2004
11/05/2004
11/05/2004
11/07/2004

Column 67 (Also from Sheet "Customer Enrollment") (2nd Priority)
----------------------------------------------------------------------------------
Name1
Name2
Name2
Name3
Name4
Name1
Name3
Name6
Name4
Name4
Name5



Can anyone help to guide me through this, Ive been beating myself u
over this one for a couple of days.

Thank you.

Mike

===============================================
_Sample_of_what_I_would_like_to_return:_

if seaching for date: 11/01/2004 Return:

11/01/2004 Name2
11/01/2004 Name3
11/01/2001 Name4

if seaching for Date: 11/05/2004 return:

11/05/2004 Name4
11/05/2004 Name

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