Hi,
I have a process where I need to compare two excel worksheets for differences. The 2 worksheets should be identical so any differences should be highlighted.
I know there options within excel itself but as this will be a regular process and needs to be undertaken on a large number of worksheets I was wondering would the Mr excel community have any recommendations on excel comparison tools.
Ideally if you could compare entire workbooks containing individual worksheets that would be ideal but worksheet by worksheet would also work .
Any info or tips on this is greatly appreciated.
I have a process where I need to compare two excel worksheets for differences. The 2 worksheets should be identical so any differences should be highlighted.
I know there options within excel itself but as this will be a regular process and needs to be undertaken on a large number of worksheets I was wondering would the Mr excel community have any recommendations on excel comparison tools.
Ideally if you could compare entire workbooks containing individual worksheets that would be ideal but worksheet by worksheet would also work .
Any info or tips on this is greatly appreciated.