September 20, 2018
Can anyone help on this VBA scenario.
I have two sheets Sheet1 & Sheet2. I want to compare two sheets and to display the difference rows and columns of each cells in the sheets.
Sheet2 data willbe in any random order compare to sheet1.Please refer sheet2 datas.
1. I have to identify and display the missing Row from sheet1. Please refer "Missed Row SeqNo from Sheet1" header.
2. I have to identify and highlight the Srefcol Data changed which i have highlighted in yellow in sheet2.
3. I have to identify and highlight the SrefActive Data changed which i have highlighted in yellow in sheet2.
Can anyone please help on how to achieve this!
November 8, 2013
What version of excel are you using?
If you have the Proffesional Plus version of office, you can use the workbook Compare tools from the Inquire tab: Turn-on-the-Inquire-add-in
You can separate those 2 sheets into different workbooks and compare them using this tool.