Hi there,
I need a VBA to compare two columns and show a message with the number of duplicates found and then stop the user from progressing until the duplicate is made unique.
If the VBA can also highlight the duplicates, it can save me some conditional formatting too.
Example:
Thank you.
I need a VBA to compare two columns and show a message with the number of duplicates found and then stop the user from progressing until the duplicate is made unique.
If the VBA can also highlight the duplicates, it can save me some conditional formatting too.
Example:
Thank you.