Comparing 2 worksheets & creating a Diff worksheet. Formula not wo

[Bud]

Hello

Someone gave me this code to use to do a compare concatenating fields for
the compare but it doesn't correctly work. I can't figure out the code and
haven't received any further responses.

Can someone look at this and figure what needs to change and/or describe
what each part is doing? The code is below

This mainly works but it doesn't subtract accurately in all cases. There
were only 2 differences in both files but it showed more than that. Where
rows were identical it placed a difference in it.

 

[Barb Reinhardt]

This add in works quite nicely to do what you want.

http://www.cpearson.com/Zips/Compare.zip
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.