Macro: If find specific string in Column B, then replace Column A with a new String
<p>In Column B, I want to search for "hmc" and then replace its corresponding cell in Column A with the string "Found".</p>

<p>I tried to use the macro recorder to filter Column B for "hmc", and this can be done. But I need to go to Column A and replace the corresponding cell with the string "Found". </p>

<pre><code>Col A   Col B
Accept  hmc
123     hmc
Accept  xcc
Accept  xcc
123     hmc
Accept  hmc
</code></pre>

<p>Would be rewritten to:</p>

<pre><code>Col A   Col B
Found   hmc
Found   hmc
Accept  xcc
Accept  xcc
Found   hmc
Found   hmc
</code></pre>