Hi Guys,

I found a macro to compare two sheets Called : Before and After and Highlighted Differences with Yellow and works very good.

Attached Before and After Comparison Highlighted Differences.xlsm

But now I want to have the possibility to compare more than one sheet per Excel at the same time . For example

Excel 1 : Sheet 1, Sheet 2, Sheet 3
Excel 2: Sheet 1, Sheet 2, Sheet 3

and do the same logic of the macro attached Highlighted Differences with Yellow for each of the sheets 1,2,3.

Do you have any recommendation or idea on how to do this ?