title: copy/ paste data to/after the last row/column of data. from old workbook to new workbook
body: <p>I am updating a weekly Master file. As a result, I am trying to copy and paste the data from the source file to the Master sheet. Now, The data needs to be pasted to the columns and rows after the data of the previous week. So for example if last weeks data ends (&quot;H70:M70&quot;), I need the new pasted data to go to (&quot;H71:M71&quot;). Also, the new pasted data has many rows, so nexts week data has to be pasted after the last row/column of this weeks data i.e (&quot;H230:M230&quot;). Please Help.</p>
  <pre><code>Option Explicit
  Sub Copydata()
  Dim myWB As Workbook
  Dim thisWB As Workbook
  Dim thisWS As Worksheet
  
  Application.ScreenUpdating = False    
  
  Set myWB = Workbooks.Open(&quot;C:\Users\jjordan\Desktop\test.xlsx&quot;)
  
  myWB.Sheets(&quot;Sheet1&quot;).Range(&quot;A8:F17&quot;).Copy
  
  Set thisWB = ThisWorkbook
  Set thisWS = thisWB.Sheets(&quot;Test data&quot;)
  
  thisWB.Activate
  thisWS.Range(&quot;H71:M71&quot;).PasteSpecial _
      Paste:=xlPasteValues, Operation:=xlNone, _
      SkipBlanks:=False, Transpose:=False
  
  With Application
      .CutCopyMode = False
      .ScreenUpdating = True
  End With
  
  myWB.Close
  
  End Sub
  </code></pre>