title: Google Sheets Scripts Moving input field answers to a blank out put field
body: <p>I'm still working on a sheet for the Music Studio I work at and I have been stumped again.
  I've spent the last few days reading things like </p>
  
  <pre><code>1) https://developers.google.com/apps-script/reference/spreadsheet/sheet
  
  2)https://mashe.hawksey.info/2015/03/google-sheets-move-a-row-of-data-to- 
  another-sheet-based-on-cell-value/
  </code></pre>
  
  <p>Trying to copy a Cell from an intake form to an output column on a different sheet.</p>
  
  <p>I'm currently using this code I found on StackOverflow I tried to edit to suit my needs.</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>function NewBand(){ //Triggered by button on "New"
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var target = SpreadsheetApp.getActiveSpreadsheet();
  
    
    var source_sheet = ss.getSheetByName('New');
    var target_sheet = target.getSheetByName('Roster');
    var source_range = source_sheet.getRange('D3');
    var target_range = target_sheet.getRange('C10');
      source_range.copyTo(target_range);
    var last_row = target_sheet.getLastRow();
    target_sheet.insertRowAfter(last_row);
    var target_range = target_sheet.getRange('C'+(last_row+1));
  
    var source_sheet = ss.getSheetByName('New');
    var target_sheet = target.getSheetByName('Info');
    var source_range = source_sheet.getRange('D5');
    var target_range = target_sheet.getRange('B8');
      source_range.copyTo(target_range);
    var last_row = target_sheet.getLastRow();
    target_sheet.insertRowAfter(last_row);
  }</code></pre>
  </div>
  </div>
  </p>
  
  <p>Currently, when it runs, it correctly adds data to the correct columns, but</p>
  
  <p>1)it doesn't insert the data into the next cell preserving the previously 
    inserted data.
      -It overwrites the previous entry currently as opposed to moving down a row and creating new data.</p>
  
  <p>2) when I run it, it adds a bunch of blank rows too.</p>
  
  <p>3) if there is an easier way to do this that would also be great!
  If someone can get me on the right track or get the first form to output correctly,so i can do the rest I'd be eternally grateful!</p>
  
  <p>If it helps here is a very simple version of my project:
  <a href="https://docs.google.com/spreadsheets/d/1i192uK-a-ALim7pvL-mkty_1nh_m9aghvmrxmiiRYKs/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1i192uK-a-ALim7pvL-mkty_1nh_m9aghvmrxmiiRYKs/edit?usp=sharing</a></p>
  
  <p>I color coded the input forms in the sheet "New" to match my desired outputs on sheets "roster" and "info".</p>
  
  <p>I'd also be more than happy to tip someone a couple of bucks for their time if they have paypal or apple pay</p>