Hello, i'am trying to use macro to search through a column to find specific words
if it finds it, a value is assigned to the column next to it, it must be done in a loop and should read from each cell word by word, for example:
IF John Then ID = 256
IF John AND Smith Then ID = 231
Name ID
John Smith 231
Kurt Davis 127
This is probably simple for you guys but iam quite new at this
Thank You!
if it finds it, a value is assigned to the column next to it, it must be done in a loop and should read from each cell word by word, for example:
IF John Then ID = 256
IF John AND Smith Then ID = 231
Name ID
John Smith 231
Kurt Davis 127
This is probably simple for you guys but iam quite new at this

Thank You!