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: