Find and copy rows in one excel file that are not in another file

[wishes123]

Hi,

I have two excel files, the first is 'Old_tenders' and the second is 'New_tenders'. Both contain the same columns about tenders, however, New_tenders includes new rows that are not included in Old_tenders, I need to find these new rows and put them in Sheet 2 of the New_tenders file.
The column I'm thinking to use is A, which has the title 'RFP Title', it has alphanumeric values.

Could any one help me in creating a function or a macro to execute this,

Thanks in Advance,
wishes

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showth...n-one-excel-file-that-are-not-in-another-file

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).