0

Afternoon, I have this script where if I press delete, or edit, it takes the value and puts it in A6. Now I'm wondering how I make it so that if the cell value is from column A, it puts it in A6, but if the cell value is in column B, it puts it in B6? I'm very new to scripts, and I have tried searching for answers. I have 8 other columns to do this for, but would like if someone could show me an example, and I can carry on?

function cellValue() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('2');
  var cell = ss.getActiveCell();
  var value = cell.getValue();
 var range = ss.getSheetByName('2');


  cell.copyValuesToRange(range,1,1,6,6);

}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.