What I need is a macro that will search for a given string in Column A, then enter a value into Column B for rows where that string is found. For example, this macro could turn this:

  A             B

Foo
Bar
Stuff
Foo
Stuff
Foo
Foo
Bar
into this:

  A             B

Foo          Yes
Bar
Stuff
Foo          Yes
Stuff
Foo          Yes
Foo          Yes
Bar
Sorry for the newbie question, but my Google-fu is lacking today. Your help is appreciated.