title: Recording Values from Workbook_1 onto Workbook_2
body: <p>Having issues linking the values from Workbook_1 to appear on Workbook_2. I am not seeing the syntax error. Set Capture line is flagged. Any help much appreciated.</p>
  <pre><code>Sub RecordData()
  Dim NextTime As Date
  Dim Interval As Double
  Dim cel As Range
  Dim Capture As Range
  
  Application.StatusBar = &quot;Recording Started&quot;
  Set Capture = Workbooks(&quot;Workbook_1.xlsm&quot;).Worksheets(“Dashboard”).Range(&quot;A22:B22&quot;) 'Capture this row of data from Workbook_1
  With Worksheets(&quot;Log&quot;) 'Record the data from Workbook_1 on this sheet on Workbook_2
      Set cel = .Range(&quot;A2&quot;) 'First timestamp goes here
      Set cel = .Cells(.Rows.Count, cel.Column).End(xlUp).Offset(1, 0)
      cel.Value = Now
      cel.Offset(0, 1).Resize(Capture.Rows.Count, Capture.Columns.Count).Value = Capture.Value
  End With
  NextTime = Now + TimeValue(&quot;00:01:00&quot;)
  Application.OnTime NextTime, &quot;RecordData&quot;
  End Sub
  </code></pre>