To clarify futher:

The end user will be entering just one date at a time... He/she want
to pull all customer records on the worksheet that are listed in colum
68 for a specific date. Lets say 10/23/2004.

so the user types 10/23/2004 in the input box.

and maybe 10 different customers will be returned for 10/23/2004.

right now, because my for each statement doesnt work (or maybe Im usin
the wrong logic) I only get the first customer record on the workshee
for 10/23/2004 even though there are 9 more records on that date.

Any Ideas

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