I have attached my excel sheet. I will will have endless rows, but right now my example shows 9 rows with columns A -K so for example, if row 3 column K in the "2013" worksheet has complete then it will move it over to the "completed" sheet but now that column 3 will be blank and I want the next cell with all the values to move up and so forth. I hope this makes sense.
i currently have a macro set up that everytime I enter "complete" in column K then it will move that row to the completed sheet and so on. But I don't know how to have it so that when that row is removed then the next row automatically moves up.