I have two Excel files. One an official-central data source file with records for each contract # that is considered complete. The other is a localized data source file with records for each contract # that may or may not be completed. I need to be able to create a new file which only contains records from the local file that do not have a contract # match in the central file.

I need to be able to automate the following process using, ideally, a vb script or wsh.

Files---
FileA
FileB
FileC

1. For each record in FileB, extract the 2nd column which is the contract #.

then

2. Compare the string against each record in FileA for an exact match.

then

3. Create and populate FileC with the records from FileB that do not have a match in FileA.

Thanks for any help you can give. I might even be able to import FileA into FileB as worksheet 2 then generate worksheet 3 from them.