Don
Basically I am creating a record of voter history for a local group. I have an Excel sheet that is the current reigistered voter list in my city (including names,addresses, age, etc.) all in unique columns. I also have a list of everyone that voted in the 2002 elections (in the same format). I need the 2002 voter reord to be compared to the current voter list and if the names are on both (which means they voted in 2002) then some entry needs to be made in the current registered voter list (Any entry, any cell, same row)
Here is the main problem. I need to compare both the "FirstName" and "LastName" columns. And, these databases contain 12,000 and 8,000 records respectively.