Macros search for names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to build a macro so I can do a search on a worksheet to find a
specific list of 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
 
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.
 
Back
Top