Thread: How do I compare 1 excel file to another and save what is a match
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do I compare 1 excel file to another and save what is a match
Start by looking a Chip's index: http://www.cpearson.com/excel/topic.htm
He has a number of "Duplicate" entries; I expect one will answer your
question.
If not please come back
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DSerum" wrote in message
...
If I have Excel file-1 with 100 records and Excel file-2 with 1000
records.
How can I compare records between the two and only save records or flag
records that have a match ???


Reply With QuoteReply With Quote