Auto Fill Column with VBA Code if condition is Matched

[MHA535]

[FONT=&quot]Hi[/FONT]
[FONT=&quot]I have Multiple Entries of Same Bulk Code in Excel Sheet[/FONT]
[FONT=&quot]I'm looking for VBA Code with the following Condition[/FONT]
[FONT=&quot]If one entry of bulk code contains Intermediate against it in Material Type, for all entries where that bulk code appears, display bulk received as YES(See Screenshot)


https://www.dropbox.com/s/3we37vgkn7hloo3/Bulk Code.jpg?dl=0[/FONT]
[FONT=&quot]

[/FONT]