Macros search for names
 

Is there a way to build a macro so I can do a search on a worksheet to find a
specific list of names?

Macros search for names
 

specific list of names?
Which means??
Look in the vba help index for FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gwtechie72" wrote in message
...
Is there a way to build a macro so I can do a search on a worksheet to
find a
specific list of names?

Macros search for names
 

What I am trying to do is, have a macro search a list for 120 names, and
pull only a specific list of names along with there stats

"Don Guillett" wrote:

specific list of names?
Which means??
Look in the vba help index for FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gwtechie72" wrote in message
...
Is there a way to build a macro so I can do a search on a worksheet to
find a
specific list of names?

Macros search for names
 

You don't really give much information, do you? I suggested looking in the
vba help index for FINDNEXT. Did you do that? You could then incorporate
that within a for/next look looking for each name on your short list in the
longer list. When found, you can copy the cell(s) to the next available row
elsewhere.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gwtechie72" wrote in message
...
What I am trying to do is, have a macro search a list for 120 names, and
pull only a specific list of names along with there stats

"Don Guillett" wrote:

specific list of names?
Which means??
Look in the vba help index for FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gwtechie72" wrote in message
...
Is there a way to build a macro so I can do a search on a worksheet to
find a
specific list of names?