My Tool for comparing two EXCEL workbooks using EXCEL-VBA

How to compare two Excel WorkBooks?

There are many tools and solutions for comparing two workbooks being used. Many MVP for EXCEL suggested a method for this. I want to share the method which I am currently using for comparing two books. For this purpose I created a small and simple workbook.

Here is the screen shot of the workbook. Bigger view of the same screen shot

You can email me to have your own copy of this tool free of cost.

I dont know how to publish this XLS file for sharing. I need help in this regard.

One more quick method for single sheet workbook is

• Open two books in different windows
• Create a new blank workbook
• Type the formula =[Book2]Sheet1!$A$1=[Book1]Sheet1!$A$1
• Change the above formula from absolute address to relative address (remove $)
• =[Book2]Sheet1!A1=[Book1]Sheet1!A1
• Copy this formula to required range area
• You can see TRUE or FALSE based on the values in both sheets
• You can use FORMAT / CONDITIONAL FORMATTING
• set Cell Value Equal to FALSE
• select FORMAT
• select PATTERNS and select a flourescent color.
  
  I hope you will like and use this trick for comparing two sheets.
  
  Cheers friends! Have a look at my other posts also. karthiganesh@yahoo.com