How do I compare 1 excel file to another and save what is a match
 

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 ???

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 ???