Skip to content

Instantly share code, notes, and snippets.

View mjdebeer's full-sized avatar

Marius de Beer mjdebeer

  • Capitec
  • Cape Town
View GitHub Profile
/* Global variables */
const ss = SpreadsheetApp.openById('1zumu5PGT0HJDM8ceErBaldfr1kN2-i1L0sAwT_1WjYc');
const gid = ss.getSheetId();
const artists = ss.getSheets()[0];
const template = ss.getSheets()[1];
function copyFormat() {
const sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(2, 1, 1, lastColumn).copyFormatToRange(sheet, 1, sheet.getLastColumn(), 3, sheet.getLastRow());
}