Max, I tried your download and it appears to work except for one thing. The
column of names in the worksheet that I am trying to search is not just
names. It MAY be just names but it may also be a first name, last name, age,
city and state, all in the same column. so now somehow I have to search that
column and be able to filter out the rest of the information for the search.

Hope that makes sense

Thanks again

"Max" wrote:

Here's a link to a demo file with the implemented set-up:
http://www.savefile.com/files/5254674
File: Search_n_extract_rows_using_list_from_anothersheet .xls
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--