Hey all,
is there any way to compare two worksheets? The limitations in the worksheet are:
1. The cells in some columns are merged.
2. However, all the data, whether merged or not, the formated remains the same. I meant if a1 and a2 are merged in sheet A, the same a1 and a2 are merged in Sheet B.

Please help if there is any way to compare the worksheet.
Also am not good at script. Please specify if there is any method for that.
Your quick response is appreciated.
Thanks,
Pravi