Thread: [Solved] How to write a macro to find a specified name in a list of data?
View Single Post
 
Old 10-23-2010, 02:39 PM
MWE MWE is offline Windows XP Office 2003
Novice
  
Join Date: Oct 2010
Posts: 8
MWE is on a distinguished road
Default
Quote:
Originally Posted by Jaffa View Post
Hi

Can anyone help me write a macro that will find a specified name in a list of data?

Also a macro that will say if the specified name exsits in the list or not.

Hoping someone out there can help!
I can help you out. A few quick questions:
  1. how will the macro know where the list is? The easiest approach would be for you to select the cells that constitute "the list" and then run the macro.
  2. how will you tell the macro what name you want to find? Should the macro just ask?
  3. is the search for a single word, e.g., Jones or multiple words, e.g., John Johns? If the latter, are the first and last names in different cells?
  4. do you want the macro to care about upper vs lower case? If it does not care then JONES and Jones are the same.
  5. you state that you want the macro to tell you if the specified name is in the list or not; do you also want it to tell you if the name occurs more than once?
  6. assume that the name exists in the list, do you want the macro to select the appropriate list entry?
Reply With Quote