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.
Bookmarks