title: Vba copy to autofilter
body: <p>I would like to copy a value (cell content is a vlookup formula) from sheet 1 to sheet 2. And in sheet 2 it needs to be filled in within an autofilter. I recorded the macro but i cannot create a paste special (value only thus) within the "critical". </p>
  
  <p>Now VBA keeps using the "consultancy"-value only and if cell A23 changes (due to the vlookup formula) it does not uses the new value.</p>
  
  <p>Could you please help me out?</p>
  
  <pre><code>Range("A23").Select
  Selection.Copy
  Sheets("Theory").Select
  ActiveSheet.Range("$A$1:$AR$2653").AutoFilter Field:=3, Criteria1:= _
      "Consultancy"
  Sheets("Practice").Select
  </code></pre>