title: Copy value from specific cell in google spreadsheet to another via button
body: <p>On the click on a Button I want a function to be triggered that copies the value from <b>Sheet1!A6</b> to <b>Sheet2!A6</b>. <a href="https://docs.google.com/spreadsheet/ccc?key=0AveLEDuTZv0vdGYyWl9tLUZ5YmFKUE9Za2VqUVRVcEE&amp;usp=sharing" rel="nofollow">(see template) </a>! 
  What do I have to add to this to make it work?</p>
  
  <pre><code>function CopyPasteA6() {
     var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet1');            
  
     sheet.getRange('A6').value
      ???
  }
  </code></pre>
  
  <p>Thanks for help!</p>