Start by looking the the vba help index for FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DebraR" wrote in message
...
I have a spreadsheet with a variable number of matches for each ticket
number. I need to find all of the instances and place the data in another
spreadsheet. I'm trying to figure out the formula and then need to imbed
it
in a macro.

Help, this this project was due on 12/31/08 and now I'm in the next year!

Thanks.