title: VBA paste on next empty row
body: <p>I am trying to create a sheet that I can fill in, when i click the button it copies the information from the box and paste (and Transpose) to the Rawdata tab, then deletes the information from the Dashboard and saves the file. </p>
  
  <p>I have recorded a simple macro to do this for me, but the problem is that I dont know how to get it to add the data to the next free row, it just replaces the information already there, this is the code i am using to try make it happen</p>
  
  <pre><code>Sub Macro5()
  '
  ' Macro5 Macro
  '
  
  '
  Range("C3:C8").Select
  Selection.Copy
  Sheets("RawData").Select
  Cells(Range("C1000000").End(xlUp).Row + 1, 3).PasteSpecial Paste:=xlValues, 
  Operation:=xlNone, SkipBlanks:= _
  False, Transpose:=True
  Sheets("Dasboard").Select
  Application.CutCopyMode = False
  ActiveWorkbook.Save
  Range("C3:C8").Select
  Selection.ClearContents
  End Sub
  </code></pre>
  
  <p>any help here would be much appreciated.</p>
  
  <p>I need it to transpose paste in the A:F columns </p>
  
  <p>thank you</p>