Very basic macro question (find and append)

[Orzabal]

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:

Please Login or Register  to view this content.

into this:

Please Login or Register  to view this content.

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

[Schwizer]

Try pasting this code into one of the cells and then dragging the formula to all the cells. Note that A6 would the the cell to the left of the cell in column b (in the same row). You can replace Foo with other things you would like to find.

=IF(A6="Foo","Yes","")

hope that helps

Schwizer

[Orzabal]

Schwizer,

Thanks, that works for the time being.

What I actually have is a spreadsheet of stuff organized by city, and I need to add a column for "region". New York is always going to be in the Northeast region, Miami in the Southeast, and so on, so I'd like a macro that searches for "City X" in Column C and puts "Region X" in Column D. The cities and regions are always going to be in columns C and D, respectively. This needs to be done in multiple documents, which is why it'd be great to have it in macro form.