pawasthi
06-17-2011, 11:34 AM
Hi All,
First of all, thanks to all contributors of this forum. Friends, this time I have to compare two excel sheets for data.
1. Data may be modified in cells.
2. Rows can be deleted
3. Rows can be added
So basically I have some data in old sheet but in new data sheet, some rows are added, deleted and modified. (Also the data may be sorted in the new data sheet so row sequencing could be different in both sheets)
Please help me out with this..
I have read somewhere this can be done via VLookUP..But i dnt know how..
Please find the attached sample sheets.
First of all, thanks to all contributors of this forum. Friends, this time I have to compare two excel sheets for data.
1. Data may be modified in cells.
2. Rows can be deleted
3. Rows can be added
So basically I have some data in old sheet but in new data sheet, some rows are added, deleted and modified. (Also the data may be sorted in the new data sheet so row sequencing could be different in both sheets)
Please help me out with this..
I have read somewhere this can be done via VLookUP..But i dnt know how..
Please find the attached sample sheets.