Excel addin or macro to compare spreadsheets

[rxk]

Hi,

I need help to compare 2 different spreadsheets. I would like to compare 2 MTO spreadsheets and highlight surplus and shortfall quantities.

thank you

[alexanderchacin]

Hi,

I need help to compare 2 different spreadsheets. I would like to compare 2 MTO spreadsheets and highlight surplus and shortfall quantities.

thank you

Maybe something like "= Sheet2! A1 = Sheet3! A1" in all your data?