Comparing data in 2 worksheets & marking them if the respective cells donot match

[surya prakash]

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

[Aussiebear]

Sure can. Look up Match in the Help files and you need to bear in mind that you will be constructing code for a "If Not Match...Then"

[surya prakash]

Hi,
thanks Aussiebear,
I am wondering if there is a VBA solution for this..

thanks

[herzberg]

Check out the attached workbook for my approach on this. I don't think it's very elegant but it works.

[surya prakash]

Check out the attached workbook for my approach on this. I don't think it's very elegant but it works.

Hello herzberg,

Many thanks for your solution; it works fine with the test problem.
Let me try out on my problem and revert back.

thanks again...