title: Click a cell to add a string to the bottom of a list
body: <p>I'm very new to using macros in Excel, so I hope this question isn't too silly.</p>
  <p>I'm creating a worksheet to track sales. I've got a list of drinks in one column and I wanted to assign a macro to the cells so that when you click on them, the text in their cells is copied to another column.</p>
  <p>I know you can record macros to copy-and-paste values, but I'm not sure how to make it copy the text in the next empty cell in the column, and not just in the first cell.</p>
  <p><a href="https://i.stack.imgur.com/toEoM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/toEoM.png" alt="enter image description here" /></a></p>
  <p>So in summary, these are my tables. I want to be able to click a cell in the <strong>Drinks</strong> column, and have the string appear at the bottom of the <strong>list</strong> column (so after 'Cuba Libre')</p>
  <p>Thanks!</p>
  <p><strong>EDIT_1:</strong></p>
  <p>Ok, so here's my code so far:</p>
  <pre><code>Option Explicit
  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
     If Target.Address = &quot;$C$2&quot; Then
         Range(&quot;C2&quot;).Select
         Selection.Copy
         Range(&quot;A2&quot;).Select
         ActiveSheet.Paste
     End If
  End Sub
  </code></pre>
  <p>^I've repeated this code for each of the relevant cells in column C (C2:C5).</p>
  <p>Like I said, I've only gotten to the point of being able to copy paste the values from the <strong>Drinks</strong> column into the <strong>List</strong> column, I am lost as to how to paste the value into the next empty cell.</p>