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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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/duplic...tractingUnique
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bt707" wrote ...
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. --- BT