hello and thanks for helping
I cant seem to quite find what I am looking for so here it goes,
I am looking through column A for "*West"
then, if the next cell down is blank, I want it to = *West,
if the next cell down has data, I want it to stop
I started with this, and had no luck...