How to compare to spreadsheets?

[elena7]

I have an Excel report which outomatically run from Access every week. Is it possible to see the list of changes or highlight chenges on the new report comperative or the old one? What is the easiest way to compare two equally formatted spreadsheets?

Thanks alot for your help,
Elena

 

[Ekim]

Elena,

Myrna Larson & Bill Manville have a free addin called "Compare" at
http://www.cpearson.com/excel/download.htm

It should do what you want. This method assumes that the sheets are similar.

Regards,

Mike