How to compair 2-spreadsheets & find mis-matching cells ?

I need to compair 2 very complicated spread sheets and find the cells that
do not match.

Can anyone tell me a way to do this?

The cells contain text and numbers.

Thanks for any help on this.

Chip has lots of good stuff to COMPARE worksheets.
See www.cpearson.com
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Will" <[email protected]> wrote in message
news:%[email protected]...
>I need to compair 2 very complicated spread sheets and find the cells that
>do not match.
>
> Can anyone tell me a way to do this?
>
> The cells contain text and numbers.
>
> Thanks for any help on this.
>
>
>

I use Jim Cone's Add-in called XLCompanion..........it does a super job.

Vaya con Dios,
Chuck, CABGx3


"Will" <[email protected]> wrote in message
news:%[email protected]...
> I need to compair 2 very complicated spread sheets and find the cells that
> do not match.
>
> Can anyone tell me a way to do this?
>
> The cells contain text and numbers.
>
> Thanks for any help on this.
>
>
>

I would reccomend uninstalling excel and using a database instead