I hope you are fine, THANKS for helping me as always
Ok I managed to load the three macro/procedures in a file along with the raw data, so no need ( I hope) to send the personal file too.
I tried to comment each action of all the procedures , I hope this can help you reading the code.
Our main target stays as : to have the formats of the values in sheet2 columns D:E be dynamically concatenated along with the values.
the three procedures are:
run First Step of Tool Basically it prepares the two sheets for the comparison
run Second Step of Tool Compare the two sheets and get rid of formulas to make the two sheet lighter when working with filters.
run Reset of the tool. Reset the tool. (I have a better version of this very basic reset but I left the file with the macro in my laptop I will send it to you later if you want)
Reply With Quote