Excel Macro
http://exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html
Compares the 2 Worksheets and pops up a workbook with the differences:
Steps:
>Tools > Macro >Macros >Run
Excel Function
Function for comparing data: http://office.microsoft.com/en-us/excel/HP100625641033.aspx?pid=CH100645341033
Here's the Excel formula: =Exact(ColumnRow,ColumnRow)
An example: =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".
No comments:
Post a Comment