Compares the 2 Worksheets and pops up a workbook with the differences:
Steps: >Tools > Macro >Macros >Run
Function for comparing data: http://office.microsoft.com/en-us/excel/HP100625641033.aspx?pid=CH100645341033
Here's the Excel formula:
=EXACT(G5,P5) [First put both worksheets on the same worksheet, side by side.]
If the result is True data matches; if False data does not match
Also, I was told there is a way to recieve as output each row that was different using a "Filter".