I've got 4000 names in Sheet 1 and I've got 200 names is Sheet 2. The names of 200 person in Sheet 2 also contain in Sheet 1. I would like to ask how can I eliminate names in Sheet 1 (4000 names) based on names in Sheet 2 (200 names).

Please explain more exactly what you want to happen and where.

1) The names in sheet2 should disappear from Sheet1?
2) The names in sheet2 should highlight on sheet1?

To actually remove the names from the actual data on Sheet1 will require VBA. Is that OK?