I have a spreadsheet that looks like this:

C D E F G
H I
row 29 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan
24- Jan
row 30 DISC
row 31 ed
row 32 25-Jan 26-Jan 27-Jan 28-Jan 29-Jan 30-Jan
31- Jan
row 33 DISC
row 34 ed

What I need to be able to do is search for each occurance of the "DISC" and
then use the date (the cell above the "DISC") on a different worksheet in the
workbook that contains summary information. I need to be able to report each
date that the "DISC" code occurs.

I hope this all makes sense !

Thanks in advance for any suggestions !