Macro set to move completed cell to new worksheet now need to delete empty cells up

Hi,

Please help! I have an excel spreadsheet with two worksheets title "2013" which is any pending work and "completed" sheet. My xcel sheets are exactly the same with A thru K columns. I currently have a macro set that if anything in column K says "complete" then it removes that entire row A-K to the completed sheet; however now my 2013 sheet where I originally have pending work has an empty cell and I don't know how to automatically move the empty cell up by one.

I'm attaching my xcel log so you can see.

Re: Macro set to move completed cell to new worksheet now need to delete empty cells

Hi! Thank you! I'm fairly new with macros and excell and learning. Do I insert this macro in a new module or where my existing macro is?

Re: Macro set to move completed cell to new worksheet now need to delete empty cells

I have attached my excel sheet. I will have possibly endless rows, 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.

Re: Macro set to move completed cell to new worksheet now need to delete empty cells

I entered that code in a new module and I get "compile error: invalid outside procedure" message.