Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save kenmhaggerty/6a6566cacfccdf33daf06fc5604d6bad to your computer and use it in GitHub Desktop.
Save kenmhaggerty/6a6566cacfccdf33daf06fc5604d6bad to your computer and use it in GitHub Desktop.
var sheetName = "Sheet1"; // name of your sheet
var firstRowOfData = 2; // first row of data
var firstColumnOfData = 2; // first column of data where A = 1
var lastColumnOfData = 3; // last column of data where A = 1
function onEdit(e) {
Logger.log("[METHOD] onEdit(e)");
if (e.source.getActiveSheet().getName() !== sheetName) {
return; // don't continue if a non-relevant sheet was edited
}
var range = e.range;
var lastRow = range.getLastRow();
var firstColumn = range.getColumn();
var lastColumn = range.getLastColumn();
if ((lastRow < firstRowOfData) || (firstColumn > lastColumnOfData) || (lastColumn < firstColumnOfData)) {
return; // don't continue if edited cells do not include any relevant data
}
var firstRow = range.getRow();
var numRows = range.getNumRows();
var numColumns = range.getNumColumns();
var values = range.getValues();
var row;
for (i = Math.max(firstRowOfData-firstRow, 0); i < numRows; i++) {
row = values[i].slice(Math.max(firstColumnOfData-firstColumn), 1+lastColumnOfData-firstColumn);
// PERFORM ACTION HERE FOR EACH ROW OF EDITED DATA
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment