View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MWS MWS is offline
external usenet poster
 
Posts: 53
Default Systematically Identifying Duplicate Records

Can anyone provide code to address the following issue:

Background
Via a control, my program imports records into an excel spreadsheet - cell
A1000 (the imported data actually populates A1000 through I1500). Previously
imported data already occupies cells A1:I100 (Column "I", of both sets of
data, contains a unique record key). The program then continues with
formatting, computing, etc.

Issue
What I need to address is, if any of the new data records match any of the
previously imported data, I want to abort the program (if any record in range
I1:I100 matches any record in I1000:I1500). This will prevent duplicate
records from being systematically input into the file.

Can anyone provide the code to address this situation?

Any and All Help Will Be Appreciated - Thanks In Advance!!!!