title: Excel: I want to populate Column A with the Contents of Column B, only if Column B value starts with F
body: <p>I have two columns with different values; A and B, if the values of column B start with letter F, I want that value (the one starting with F) to replace the current value in column A. This is the VBA code I have so far, not sure if I am heading in the correct direction. </p>
  
  <pre><code>Private Sub UpdateColumnA()
  Dim x As Long
  For x = A To Z
      If InStr(F, Sheet1.Range("$B$" &amp; x), "thisvalue) &gt; 0 Then
          Sheet1.Range("$A$" &amp; x) = Sheet1.Range("$A$" &amp; x) &amp; "sometext"
      End If
  Next
  End Sub
  </code></pre>
  
  <p>Also, I am not sure what content should be placed in pieces of code "thisvalue" and "sometext"</p>