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.