title: Excel - Copy selected cell and paste to the end of a column in another worksheet
body: <p>I'm very new at VBA and looking to copy the selected cell's contents and paste them to the next available row in Column B of Worksheet "Draft".</p>
  
  <p>I was able to figure 2 other simple macros I needed out but could figure out how to put them together to figure this out.</p>
  
  <pre><code>Sub CopyName()
  'Copy's selected cell to cell K2 within same worksheet... which then triggers vlookups with additional info
  
  Selection.Copy
  Range("K2").Select
  ActiveSheet.Paste
  End Sub
  
  Sub SelectPlayer()
  'Copies name pasted in K2 , to next available row in column B of other worksheet
  
  Worksheets("Draft").Range("B" &amp; Rows.Count).End(xlUp).Offset(1) =       Worksheets("Dashboard").Range("K2").Value
  
  
  
  
   End Sub
  </code></pre>