First, you guys are awesome. You solved my last problem perfectly. Of course, since no good deed goes unpunished, I have another question.
Spreadsheet 1, "NPI.xls" contains (among other things) the following fields
A1 - NPI (it is a unique ID for a doctor)
B1 - Last Name
C1 - First Name
D1 thru H1 - Address information (addr1, addr2, city, state, zip)
(There are around 13,000 rows)
Spreadsheet 2, "PECOS.xls" contains
A1 - NPI
B1 - Last Name
C1 - First Name
(around 60,000 rows)
What I want to do is go to spreadsheet 2 and select the first NPI, find it in spreadsheet 1. If found, then compare to determine if last name and first names are identical. There is no certainty that the find will work. If the find fails or succeeds, fine, move on to the next row.
Thanks!
Pete
Spreadsheet 1, "NPI.xls" contains (among other things) the following fields
A1 - NPI (it is a unique ID for a doctor)
B1 - Last Name
C1 - First Name
D1 thru H1 - Address information (addr1, addr2, city, state, zip)
(There are around 13,000 rows)
Spreadsheet 2, "PECOS.xls" contains
A1 - NPI
B1 - Last Name
C1 - First Name
(around 60,000 rows)
What I want to do is go to spreadsheet 2 and select the first NPI, find it in spreadsheet 1. If found, then compare to determine if last name and first names are identical. There is no certainty that the find will work. If the find fails or succeeds, fine, move on to the next row.
Thanks!
Pete