Move a row of data from one worksheet to another based on cell value, with Google Apps Script

In Software Engineering, Snippet

A Google Apps Script to automatically move a row of data from one worksheet to another based on a value in a cell.

I would recommend using validation in the criteria cell.

EDIT (06 Sept 2012): Previously, line 23 incorrectly showed if (colIndex == 10 && rowIndex != 1) {

References:

  1. http://productforums.google.com/forum/#!topic/apps-script/IIKIWsJn4OU
  2. https://productforums.google.com/forum/#!msg/apps-script/ewnXB_gbtZ0/zbpOCJxNDKcJ

Leave a Reply