Greetings,

I've a workbook with three sheets (sheet1, sheet2 and "search results")

sheet1:

There are two columns in sheet1 with more than 2000 rows!

employee_ID Borowed_books
0e100 JChase-203
oe100 RUdlum-40
oe098 RUdlum-22
oe101 Achristi-53
oe100 JChase-06
oe098 Mpuzo-22
oe100 Pmason-42

Sheet2:

column a has list of employee id that belongs to a particular department

Employee_ID Dept Manager
oe098 xx Tom
oe099 xx Jerry
0200 xx Jerry
oe407 xx Tom
0e100


I want to pickup all cells under employee_id in sheet2 and search sheet 1
if a hit is found then copy entire row to "search results" sheet.

In the above example, the search should find oe098 (two rows) and oe100 (4
rows).. and "search result" sheet should contain 6 rows.

Any help is greatly appreciated.

Regards
Carlos