Hi All,
Found some code from an old post (http://www.excelforum.com/excel-prog...ml#post3701361) which compares data in sheet1 & sheet2 and highlights differences in both sheets.
Applied below code to my sample file (attached) but picked up some limitations which I was hoping someone could help me with:
- Code seems to stop comparing any further once it reaches a blank cell
- Compares dates and values relatively well but not text columns like people's names, department names, etc.
- There also seems to be some inconsistency in comparing which i can't quite figure out
Any help would be greatly appreciated.
![]()
Please Login or Register to view this content.
Bookmarks