Comparing difference from a Main Worksheet with other worksheets in workbook
Posted on 2013-01-31
Hello I have a mailing list in a workbook with a master list on Sheet 1
I also have Sheets 2 and Sheet 3 with portions of that same master list.
Not all of the mailing list has been copied onto sheets 2 and Sheets 3 and I want to find out which ones are missing so I can put them on Sheet 4
Only 1 column needs to be "Matched" and that would be street address.
So if the Formula (or Visual Basic) goes down the records on Sheet #1 and can't find it on Sheets #2 or SHeet #3 it needs to put it on Sheet Number 4
Does Excel (WIndows Excel 7) have a built in "comparison tool" that can do something like this? Or is there, as I said, a formula or visual basic that can do this for me.
There are about 1000 records to go through.