title: VBA: Copying a cell range to different workbook
body: <p>I am currently working on an integrated set of workbooks, where I need to transfer data values between workbooks. In order to do so I need a VBA Macro that can copy a specific range (a row in a worksheet) and insert it at the bottom of an overview list in a different book.</p>
  
  <p>How can I do this?</p>
  
  <p>I am somewhat of a VBA novice, so specific instructions are appreciated.
  Note: I'm using MS Excel 2010.</p>
  
  <p>Thank you in advance!</p>