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.