I have the attached which allows me to compare two sheets based on a config sheet:
I will like to add some requirements:
1-Include in the process check the following: If there are duplicate values in the column related to key in each sheets output a Msgbox("Unable to run the GAP as they are some duplicate values. To continue duplicate values should be removed") if the user clicks on "Yes" the duplicate values should be removed and the first value should be kept.
2-Add two additional columns for every comparison range. Actually each comparison is composed by the as shown in Gap analysis, I will like to add two columns like this with a fix name:
Admin, Reference, Required update.
This modification should be applied for the various comparison specified in Parameter sheet.
3-Highlight in green all the values which have have inconsistencies which means all the keys which have a row without any value. Highlight in light red all the keys which have an inconsistency that means all the key which have at least one value for their respective rows, please refer to Revised-Gap-Result.
4-Finish the macro with the following MsBox("Do you want to keep the values which doesn't have inconsistencies if the user Click on "Yes" all the rows related to the values highlight in green should be removed else exit the condition and continue with the other action.
Thank you very much for your help.