How to Compare two Excel Workbooks on Single click By Using Macro

          When you have two similar Excel workbooks, or better say two versions of the same workbook, what's the first thing you usually want to do with them? Right, compare those files for differences. There were many solutions given on the internet, but everyone had their own drawback, e.g. viewing files side by side and then visually finding out the differences, well definitely no one would like to do this at least for the large files, or by using Excel formula like ="IF(Sheet1!A1<> Sheet2!A1,"Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1"), this also not gonna work, for alternatively we can use Vlookup, Index Match function  if there is any common unique value in two workbooks but doing for all columns it took more time and less accuracy.

 if there are multiple sheets doing this all the pair of sheets is a huge task. Also, there are software which compares two files, I have used few of them but they can compare only one sheet and if there are multiple sheets then one by one we can do it. And many other solutions which I am not going you through. But I was not looking for this kind of solutions, so I came up with this Macro to compare two Excel workbooks files not matter if you have a single sheet or multiple sheets, which I am going to show you. The differences will be high lighted in Red color for both workbooks.

   Steps to RUN Macro: