Thanks Max, I'll try that today to see if it's what I want.

"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
--