Macros search for names

G

gwtechie72

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

Don Guillett

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

gwtechie72

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
 
D

Don Guillett

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.
 
Top