View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hunginbk Hunginbk is offline
external usenet poster
 
Posts: 1
Default Identifying new records

How do I identify new records within worksheets that are often updated? I
received updated worksheets with thousands of records but only a handful are
new records. I am not trying to identify just the duplicate records but only
the new ones as compared to the old worksheets. What I have done in the past
was combine the old and new versions of the worksheets and try to sort
through the combined worksheet to identify just the new records, a very
involved task when there are thousands of records. Any short cuts? Thanks