Auto Move Rows when status is completed

[razprod]

Hello,

I have a worksheet that i am using to keep track of open activities. Once the status (Column A) is changed over to 'Completed' I would like to have the entire Row moved to a second sheet 'Completed' and removed from the original sheet 'Activities'

Any help would be appreciated.

thanks,

[Palmetto]

Copy this code to the Activities sheet module. It will copy, then delete, the row when the status is changed to "Complete"

Please Login or Register  to view this content.

[razprod]

Thank you very much, that worked like a charm.

I appreciate the help!

[dhermit]

Sorry to bump an old topic, but this is EXACTLY what I was looking for. However, I can't figure out how to run the module. I open VB, insert module, paste the code, but if I hit f5 or run, it comes up with a box asking me to choose a macro, with nothing listed?? Any help would be awesome, I've never used macros before.

[Cutter]

Hello dhermit, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.