Skip to content

Instantly share code, notes, and snippets.

@banan314
Created November 11, 2023 20:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save banan314/52a07d4021ae60245870649b244d5be0 to your computer and use it in GitHub Desktop.
Save banan314/52a07d4021ae60245870649b244d5be0 to your computer and use it in GitHub Desktop.
Clear contents of the balance sheet cells filled with financial data from the last year
function sheetName() {
var spreedsheet = SpreadsheetApp.getActiveSpreadsheet();
const monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
const monthSheets = monthNames.map(name => spreedsheet.getSheetByName(name));
const COLUMN_START = 6;
const DAYS_COUNT = 31;
for(var i=0; i < monthSheets.length; i++) {
const sheet = monthSheets[i];
sheet.getRange(39, COLUMN_START, 7, DAYS_COUNT).clearContent();
sheet.getRange(53, COLUMN_START, 4, DAYS_COUNT).clearContent();
sheet.getRange(59, COLUMN_START, 5, DAYS_COUNT).clearContent();
sheet.getRange(66, COLUMN_START, 6, DAYS_COUNT).clearContent();
sheet.getRange(74, COLUMN_START, 5, DAYS_COUNT).clearContent();
sheet.getRange(81, COLUMN_START, 6, DAYS_COUNT).clearContent();
sheet.getRange(89, COLUMN_START, 5, DAYS_COUNT).clearContent();
sheet.getRange(96, COLUMN_START, 8, DAYS_COUNT).clearContent();
sheet.getRange(106, COLUMN_START, 6, DAYS_COUNT).clearContent();
sheet.getRange(114, COLUMN_START, 6, DAYS_COUNT).clearContent();
sheet.getRange(122, COLUMN_START, 7, DAYS_COUNT).clearContent();
sheet.getRange(131, COLUMN_START, 6, DAYS_COUNT).clearContent();
sheet.getRange(139, COLUMN_START, 4, DAYS_COUNT).clearContent();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment