I am looking for a VB script that will:
Add the word "Duplicate" in column J for all records (except the first instance) where the corresponding value in column B is duplicated.
If there is a value in column I for any one of the [duplicate] instances of column B, than copy that I value into column I for all instances.
If any instances of the value in column B has a different I value, then highlight the cells in column I for all instances.
See the attached example. Thanks for your help.