Hi,
I have two workbooks. One containing master data, and another workbook containing similar data with same format. They both have same number of rows with all ids that match.
e.g.
master
1 a b c d
2 e a b d
3 a a c b
comparing workbook
1 a b c c
2 e b b a
3 a a c b
I want to create a macro in comparing workbook, where it goes through all ids and with each id goes through each row to find any differences in the comparing workbook data, and have it highlighed to show that the data for that specific id is different. possibly also counting the number of differences also.
could someone help me with this? Thanks.
Start Free Trial
