title: copy sheet content to another sheet
body: <p>I want to copy the content of one sheet at the end of the other, i have tried this vba code and it works, </p>
  
  <pre><code>Private Sub CommandButton1_Click()
  Sheets("B").Select
  Range("A1:H14").Select
  Range("A1:H14").Copy
  
  Sheets("A").Select
  ' Find the last row of data
  Range("B48:I48").Select
  ActiveSheet.Paste
  Sheets("A").Select
  End Sub
  </code></pre>
  
  <p>but what i want is to copy without having to specify the range of the data, because i have many files and many data and it's gonna be hard to do all of that manually and change the range a each time.</p>