title: Google Script to copy specific columns from one sheet to another sheets last row onEdit
body: <p>I am looking for some help on google app scripting. Currently I have a spreadsheet that has 3 sheets. First sheet is data that comes from a google form. Second sheet is an "open" tab and third is a "closed" tab. </p>
  
  <p>When data comes into the spreadsheet from the form it has only the columns that the form has. The "open" sheet has a combination of data from the form (sheet 1) and some additional cells to add more information to by me and not the person submitting the form. Because of this column miss-match I cannot just copy a whole row from sheet 1 to sheet 2. This also needs to be done onEdit trigger. So when an edit trigger fires, I want to store that rows data into memory and then copy column B to the last row of tab 2, column C. Column C > E, column D > B. etc..</p>
  
  <p>How would I store the whole row into memory (an array I presume), and then copy only specific cells, in a specific order into the last row of a different sheet?</p>
  
  <p>Hope that makes sense :-/</p>