I have a spreadsheet with a value in column B, a corresponding value in column I, and [needing] the word "Duplicate" in column J for all rows (except the first instance) where the value in column B is repeated. 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.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel VB Script to Fill Values Based on Common Values in an Adjacent Cell

Thread starter RobertN
Start date Nov 1, 2021
Tags

excel vba & excel

RobertN

New Member

Nov 1, 2021

I have a spreadsheet with a value in column B, a corresponding value in column I, and [needing] the word "Duplicate" in column J for all rows (except the first instance) where the value in column B is repeated.

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.