Hi,

I have got an Excel document which contains 2 different
sheets. These sheets contains customer details extracted
from 2 different systems.

The following fields are common between the sheets -

1. Customer ID
2. Name
3. Address details etc.

What I want to do is - Using the common 'Customer ID'
field, I want to compare the two sheets for checking data
integrity.

How can I do this? Do I have to do some sort of
programming or is there any other way ?

Please advise.

Thanks,

Harish M