| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search worksheet names? | Excel Discussion (Misc queries) | |||
| Can I search sheet tabs for names? | Excel Discussion (Misc queries) | |||
| Merge two spreadsheets with names database then search for duplica | Excel Discussion (Misc queries) | |||
| Move names from Search to Excel | Excel Discussion (Misc queries) | |||
| Macros & search /replace | Excel Worksheet Functions | |||
Linear Mode
