button to automatically storing/sorting data sequentially, 2nd button to recall range

Question

Sheet in question:
https://docs.google.com/spreadsheets/d/1Pl0DBdRSsnMJnMiJwHJnikypbkSPnua9HHywdd2Gti4/copy?usp=sharing/

I've managed to copy rows, but I want to exclude any rows within the source range that are empty.

Current code:

function copytestdata() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet1 = ss.getSheetByName("JOURNAL");
  var sheet2 = ss.getSheetByName("LOG");

  sheet1.getRange("A6:K12").copyTo(sheet2.getRange(sheet2.getLastRow()+1,1,1,7), {contentsOnly:true});
 }

user30hu · Answer

Copy Sorted Data

function copytestdata() {
  const ss = SpreadsheetApp.getActive();
  const sh1 = ss.getSheetByName("JOURNAL");
  let vs = sh1.getRange("A6:K12").getValues().filter(r => r.some(e => e != '')).sort((a, b) => { return a[column - 1] - b[column - 1] });
  var sh2 = ss.getSheetByName("LOG");
  sh1.getRange("A6:K12").copyTo(sh2.getRange(sh2.getLastRow() + 1, 1, 1, 7), { contentsOnly: true });
  sh2.getRange(sh2.getLastRow() + 1, 1, vs.length, vs[0].length).setValues(vs);
}

button to automatically storing/sorting data sequentially, 2nd button to recall range

1 Answers

Copy Sorted Data