umerhayyat
New Member
- Joined
- Mar 13, 2023
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Hi.
I'm wondering if anybody could help me with this or if it is possible.
I have two worksheets of data, each row is the same case on both sheets and the columns all contain the same variables I just need to know the differences between each row.
I'm looking for a VBA that could compare the two sheets row by row and output a list row by row of which cells differ?
I have tried to hunt something down but all I can find is VBA that would highlight the different cells which wont do for this task.
Any help would be greatly appreciated.
Many thanks,
Sheet1
Sheet
I'm wondering if anybody could help me with this or if it is possible.
I have two worksheets of data, each row is the same case on both sheets and the columns all contain the same variables I just need to know the differences between each row.
I'm looking for a VBA that could compare the two sheets row by row and output a list row by row of which cells differ?
I have tried to hunt something down but all I can find is VBA that would highlight the different cells which wont do for this task.
Any help would be greatly appreciated.
Many thanks,
Sheet1
1197326901 | 000207 | 002610175 | 700000 |
Sheet
1197326901 | 000205 | 002610175 | 700000 |