Last active
July 6, 2016 17:18
-
-
Save kenmhaggerty/6a6566cacfccdf33daf06fc5604d6bad to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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