title: Using Excel VB, Update a specific cell, on any change of another specific cell
body: <p>I think this should be a simple straight-forward issue, however i am very new to VB coding.</p>
  
  <p>I would like to have the contents of A1 copied to B1, with B1 completely editable, however if any changes are made to A1, the contents are again copied over to B1.
  The following code copies the contents, however on any change, but I only want it activated if changes are made to A1.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
     Range("A3").Formula = Range("A1").Formula
  End Sub
  </code></pre>
  
  <p>Thank you for your help,
  Randy</p>