How do you create a Macro to return text from multiple cells that fit your criteria?
 

Does anyone know how you create a Macro to return text from multiple
cells that fit your criteria? Let's say you have a worksheet with 100
records of people's names and various information about them (job,
age, salary, etc.). You want to create a Macro that will return the
names of everyone who fit a set of criteria you specify, i.e. Lawyers,
or Doctors AND over 50 years old, etc. Does anyone know how to do
this? Thanks.

How do you create a Macro to return text from multiple cells that fit your criteria?
 

If the XL file is closed or in a database, using ADO/SQL or DataImport
External DataNew Database query, would be the simplest route.

Otherwise, look into DataAdvanced Filter and record a macro whilst you
perform the actions.

NickHK

wrote in message
oups.com...
Does anyone know how you create a Macro to return text from multiple
cells that fit your criteria? Let's say you have a worksheet with 100
records of people's names and various information about them (job,
age, salary, etc.). You want to create a Macro that will return the
names of everyone who fit a set of criteria you specify, i.e. Lawyers,
or Doctors AND over 50 years old, etc. Does anyone know how to do
this? Thanks.