Using VBA or Excel to compare four columns of data : <p>I have one Excel worksheet with 4 columns of data. Column A and B show the name of the file and the page numbers and the data was retrieved awhile back. C and D show the name and pages but the data was retrieved this week and differs from the original. Some of the files now have more page numbers and some stayed the same. I want to find a way to either create an Excel formula or use VBA to give me the files where the page differs, so it would need to keep A and B together and then search C and D for the file name and see if the page numbers match up. There are over 9000 rows.</p>
