I want to search a specific text which is the
WorksheetA has a column
firstname and another column
lastname. So after knowing which row has the firstname and lastname I searched for, I want to set the value of cell in the same row with a specific value.
For example if this is my worksheet:
Firstname Lastname Found Matt Damon No Smith Andrew No John Smith No Tom Mark No
and my search word is
John_Smith the result will be
Firstname Lastname Found Matt Damon No Smith Andrew No John Smith Yes Tom Mark No
Any advice please how this can be done in VBA excel?