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?
 
specific list of names?
Which means??
Look in the vba help index for FINDNEXT
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search OF Macros for a specific phrase 2
Search Box 4
Create a new worksheet with a macro and giving it a specific name 4
Macro: finding a cell on one worksheet and copying to another worksheet 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Macro to display 2

Back
Top