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.

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.

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.

Hi,

You really haven't provided enough info. What does your data look like,
where is it located (addresses), what do you want it to look like. Show us
samples of the before and after.

Regarding the fact that this project was due 12/31/08 - it might be better
to start earlier in the future.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"DebraR" wrote:

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.