Hi,
You may want to refer to my article at the following link
http://office.microsoft.com/en-us/ex...260381033.aspx
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"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.