I have two worksheets...CS and CS2. I want to compare then and make sure data is the same. I used a program to compare the two but it did a cell by cell and thats not what I want.
Example: Wooksheet CS: Kroger Foods is in cell A:15 and the Shipping Cost is $10 in cell A:20....................
Wooksheet CS: Kroger Foods is in cell C:10 and the Shipping Cost is $15 in cell C:15

What I am wanting is some way to point out that Kroger Shipping in CS is not the same as Kroger Shipping in CS2.

I need a program or a way to do this. The files are huge and there is no way to go though manually and check. Human error would be too great here.

Thanks everyone,
Jerry