I have found a number of threads regarding this topic, but have not seemed to find a solution that works. I have a table of data ("Current" sheet) with column C representing the project status. When a cell in column c is set to "C" (through data validation), I would like the corresponding row of data to move to the next available row on the "Completed" sheet. Can someone please provide a solution...I can't seem to get it right.