title: How to copy values to 6 columns before the selected cell?
body: <p>My question is simple, but this is my first code in google apps script.</p>
  
  <pre><code>function copy() {
    var spreadsheet = SpreadsheetApp.getActive();
    var row = spreadsheet.getActiveCell().getRow();
    spreadsheet.getRange('A97:H99').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
  };
  </code></pre>
  
  <p>How do I copy the values from the selected / active cell to 6 columns before it? would be something similar to: Copy to active cell - 6.</p>
  
  <p>I made this code, which already copies what I need, however it is pasting inside the selected cell itself. I need -6 columns.</p>
  
  <p>Thanks</p>