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

 

[andrewkard]

Hello, why don't you want to copy sheet from old tenders file in new tenders file and compare/sort?

 

[wishes123]

I didn't know about this 'Compare', I've just searched about it and it's really amazing
what I've found is a utilization of 'Conditional formatting' [I assume this is 'Compare'] and a function called 'CountIF'
here is the link:
http://chandoo.org/wp/2010/06/17/compare-2-lists-in-excel/#second-list-only

Thanks a lot

 

[andrewkard]

Thank you for the feedback, i mean of 'Compare' that Sheet1!A1=Sheet2!A1 Btw I'm glad you solved your issue yourself.

 

[wishes123]

Actually you have provided the magical word for search 'Compare' which guided me to the solution
Now I have this case, for tenders with their deadline extended, they will be found in both files with the same RFP name, this means I won't find them by searching on the name alone, I need to copy the deadline column and run the conditional formatting again using a combined rule between the name and the deadline (name shall be equal and deadline is different), My problem is that I don't know how to get the date for the matching records and compare them, any suggestions?

 

[andrewkard]

You may use additional column with f.e. A1&B1