What is the best way to diff two excel sheets. Im looking for an intelligent diff tool like how we have for programming languages that can recognize new lines etc. instead of just doing a plain line by line comparison.
I have done my due diligence and there are discussions like this:
http://stackoverflow.com/questions/114698/how-do-i-diff-two-spreadsheets
However most of the solutions provided require the two sheets to be structurally identical without exception or a paid software.
I just wanted to know if a macro or program already exists or what the simplest way to approach this problem would be (for ex. like converting excel to xml and diffing).
Any help appreciated.
I have done my due diligence and there are discussions like this:
http://stackoverflow.com/questions/114698/how-do-i-diff-two-spreadsheets
However most of the solutions provided require the two sheets to be structurally identical without exception or a paid software.
I just wanted to know if a macro or program already exists or what the simplest way to approach this problem would be (for ex. like converting excel to xml and diffing).
Any help appreciated.