title: VBA Copy Cell value before Change event into different worksheet
body: <p>I have "Sheet10" where cell "F3" does some calculation and value changes depending on user input. User Input is on "Sheet10" cell "G6".  I would like to copy the final calculated value of "F3" before the new value in changed into "Sheet12" Cell "Q3"  Below is my code but I'm not sure where i went wrong. 
  Thanks in advance! </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
      If Target.Address = Range("F3").Address Then
  
          Worksheets("Sheet12").Range("Q3") = Target.Value
  
      End If
  
  End Sub
  </code></pre>