Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2010, 06:23 AM
Jaffa Jaffa is offline How to write a macro to find a specified name in a list of data? Windows XP How to write a macro to find a specified name in a list of data? Office 2007
Novice
How to write a macro to find a specified name in a list of data?
 
Join Date: Apr 2010
Posts: 2
Jaffa is on a distinguished road
Smile How to write a macro to find a specified name in a list of data?


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!
Reply With Quote
  #2  
Old 10-23-2010, 02:39 PM
MWE MWE is offline How to write a macro to find a specified name in a list of data? Windows XP How to write a macro to find a specified name in a list of data? 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to write a macro to find a specified name in a list of data? macro to pull data from multiple files psrs0810 Excel 2 10-25-2010 01:49 PM
Macro to remove duplicates in Refrences list HowardC Word VBA 0 05-20-2010 09:57 AM
macro for comparing data from 3 columns and pasting into another worksheet ashukla Excel 1 06-24-2009 05:01 PM
I am trying to discover how to write a comm. Add-in patc4 Office 1 06-16-2009 11:11 AM
Find and Replace Macro - A Better Way Tribos Word VBA 0 10-08-2008 03:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft