I have attached the file with the entire tool, basically you have a step one (three macros unified by the one called "MAIN") that cleans up blank spaces and get rid of weird formats and the second step, the one you already know, that actually compare the two sheets.
then you have a very rudimental Macro that is meant to reset the tool.
Maybe it is easier for you if you have the all tool.
|