Attached you will find an excellent code which cover the following question:
I would like to add additional requirements to this excellent code:
1- Allows the concatenation process for more than 2 columns
2-If destinationSheet (sheet used to paste the highlight values doesn't exist) create it
3-Take into account a flag parameter reported in Column H:
If value is equal to 1 the macro should highlight the values in ResultRange that exist
in ComparisonRangeSheet. If value is equal to 0 the macro should highlight the values in ResultRange that don't exist
in ComparisonRange always based on our keys (current comparison performed by the macro).
4-Add RowsKey N° which is the count of Result Key value located in ResultRangeSheet an ISNA/EXIST N° which is the count of Result Key values located in DesitnationResultSheet.
5-Include in the Verification process if flag parameter is different from 0 or 1 if it is the case report the error and stop the program.
The most important is to cover requirements 2, 3, 4, 5 if requirement 1 is to complicate to cover I will drop this requirement.
If you have questions, please don't hesitate to contact me.
Thank you very much for your help.