https://www.pbainbridge.co.uk/2018/12/archive-sheet-data.html

Archive Sheet Data.gs

function archiveData() {
 
  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  
  // get source sheet by name
  var sourceSheet = ss.getSheetByName('Students');
  
  // get destination sheet by name
  var destSheet = ss.getSheetByName('archive');
  
  // find current Row on source sheet
  var currentRow = sourceSheet.getActiveCell().getRow(); 

  // get number of Columns with data in
  var numCols = sourceSheet.getLastColumn();

  // get current Row of data, getRange(startRow, startColumn, numRows, numColumns)
  var data = sourceSheet.getRange(currentRow, 1, 1, numCols).getValues();
  Logger.log(data);

  // append to destination sheet
  destSheet.appendRow(data[0]);
  
  // delete current row on source sheet
  sourceSheet.deleteRow(currentRow);
  
}


function onOpen() {
  
  // add a custom menu to the spreadsheet
  SpreadsheetApp.getUi()
  .createMenu('Custom Menu')
  .addItem('Archive data', 'archiveData') // label for menu item, name of function to run.
  .addToUi();  
  
}