title: Excel Macro to copy certain columns from one workbook to another
body: <p>This is my first attempt to write VBA code. I am mimicking something I found on <a href="https://stackoverflow.com/questions/6382526/copy-column-from-one-excel-sheet-to-another-excel-sheet">stackoverflow</a>.</p>
  
  <p>I want to copy certain columns (A, B and E) from one workbook to another and also change the font and color of certain Rows and edit the text in certain cells (replace a long phrase with the word "Group").</p>
  
  <p>This is the code I copied without change:</p>
  
  <pre><code>Sub CopyColumnToWorkbook()
  Dim sourceColumn As Range, targetColumn As Range
  
  Set sourceColumn = Workbooks("Source").Worksheets("Sheet1").Columns("A")
  Set targetColumn = Workbooks("Target").Worksheets("Sheet1").Columns("A")
  
  sourceColumn.Copy Destination:=targetColumn
  End Sub
  </code></pre>
  
  <p>I get a runtime error 9 and the line below is highlighted:</p>
  
  <pre><code>Set sourceColumn = Workbooks("Source").Worksheets("Sheet1").Columns("A")
  </code></pre>
  
  <p>I am attaching the Source and Target files below as I hope they would look like at the end of a successful run. </p>
  
  <p><a href="https://docs.google.com/open?id=0B4tcwo2ZvQCRWkxxOU5xOGNSY2s" rel="nofollow noreferrer">Source File</a></p>
  
  <p><a href="https://docs.google.com/open?id=0B4tcwo2ZvQCRV0l2SmxHZkh6NFU" rel="nofollow noreferrer">Target File</a></p>