Excel compare and create

[bt707]

I have two excel files that both have one column of numbers in them. I
need to make a script that will compare the column of numbers from one
file with the other one. If I can I need to have a script to make a new
file with any of the numbers that the second file has that cannot be
found on the first sheet.

Thanks in advance for any help.

BT

 

[David McRitchie]

I think that is covered in Chip Pearson's page on duplicates
his index can be found in his topic.htm
http://www.cpearson.com/excel/topic.htm

Duplicate And Unique Items In Lists
http://www.cpearson.com/excel/duplicat.htm

Extracting Values On One List And Not Another (#ExtractingUnique)
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique