Hi. I am trying to formulate a macro that will look for rows where the status of a task is marked complete. I would then like to cut those rows from Active and paste them in the next available rows in completed. Here is the code I have so far.
I am having two problems (that I can identify) with the code so far:
1: On the initial run it correctly identifies the completed cell, but it pastes them over the top of my headings in Completed; and
2: If I run it again and there are not completed items in Active, it cuts my headings out and pastes them in row 1 of Completed.
test 2.xlsm
Bookmarks