I would use Jim Cone's fine commercial Add-in called XL Companion. It's
available at
http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3



"AngelaD" wrote:

I am trying to compare workbook 1; sheet 1 to workbook 2 sheet 1. I want my
ID numbers, last name and first name in workbook 1 to match whatever is in
workbook 2.

There are about 3000 records in each. What is the best way to accomplish this?