surya prakash
10-25-2007, 12:16 AM
Hi,
I have data in two sheets which needs comparision.
I am wondering if it is possible to compare cells of "reference" and "test" sheets.
If the data in "test" sheet doesnt match with data in corresponding cell of "reference" sheet, it has to be marked in "Red"
Sample data is enclosed for ready reference with sample marking..
thanks
I have data in two sheets which needs comparision.
I am wondering if it is possible to compare cells of "reference" and "test" sheets.
If the data in "test" sheet doesnt match with data in corresponding cell of "reference" sheet, it has to be marked in "Red"
Sample data is enclosed for ready reference with sample marking..
thanks