Hey jindon, thank you! I got an error on this line of code for the Compare Sub.

If Not rng2 Is norhing Then Set rng1 = Union(rng1, rng2)
I could not try out the Summarize code. Do you know the issue with the above? I cleared all then imported both files, then clicked the Compare button and got the error.