title: How do I copy data from range of one book to range in another book?
body: <p>I'd like to copy values from the workbook "Consulting-for Paracon_aax.xls" for a range "E24" to "Q24" to a workbook named "2014 - XPERT.xlsm" on a range "E9" to "Q9" in a sheet named Delivery.</p>
  
  <p>This is what I've come up with.</p>
  
  <pre><code>Sub UpdateLinks()
  
  'open the source workbook and select the source sheet
  Workbooks.Open Filename:="C:\Users\desmondm\Desktop\Consulting-for Paracon_aax.xls"
  
  Sheets("Sheet1").Select
  
  ' copy the source range
  
  Sheets("Sheet1").Range("E24").Select
  
  Selection.Copy
  
  ' select current workbook and paste the value at E9
  Workbooks("2014 - XPERT.xlsm").Activate
  
  Sheets("Delivery").Select
  
  Sheets("Delivery").Range("E9").Select
  
  ActiveSheet.Paste
  
  Application.CutCopyMode = False
  
  ActiveWorkbook.Save
  
  End Sub
  </code></pre>
  
  <p>My macro only copies cell E24 from the Consulting-for Paracon_aax.xls to E9 in the Delivery sheet within the 2014 - XPERT.xlsm workbook.</p>