I want to know the easiest way to compare data between two different Excel files.Both the files are same in structure but data can be different.
The excel file has multiple sheets say around 50.
Please suggest a solution. I am trying to avoid creating configurable columns for comparing data.
Also in case if there is some change in the structure of the files then what can be done. Change in teh sense that one extra column, different name of column.