Need help automating task tracker for team= Please help.

All-

In order to help my team and I stay on top of all the current project tasks on our plates, I've put together the attached tracker. For confidentiality reasons, I've erased the contents of columns B & C.

I've looked on-line for some time and have had no luck. In new to the VBA world and wasn't able to get anything I found to work.

Here is what I'm looking to do.

When something a row on Column D is marked "Done" the whole row is automatically moved to the "Completed Tab"

Team Tracker-Clean.xlsm

P.s. This is my first post! There is so much valuable information in the forum. I look forward to learning from all of you and hope that one day I've learned enough to help others.

Hi jmawea

Try this code in Worksheet "Active"

Please Login or Register  to view this content.

A+

Hi,

Originally Posted by jmawea

On column D, we use dates until it's it is marked "Done" at that point I asks if I want to move and if yes, it works perfect.
Is there a way to remove the question and only move the row when marked done and not promoting to move if I just update the cell?

Yes, delete line

Please Login or Register  to view this content.

and the line before the last

Please Login or Register  to view this content.

Thanks- That got rid of the question, but if i update the cell on row D, it move it to the completed Tab.
Here is what i'm looking for.

If date is changed: No Action- Row stay in place, no question is asked
If date is changed to "Done" The Row is moved to the completed tab

the latter is working, but when I change the date, the current code moves the cell to the complete tab....

Thank you in advance

Hi

Haaaa oups ;-)

The correct code

Please Login or Register  to view this content.

Sorry

Originally Posted by jmawea

Absolutely fantastic! This is perfect. I really appreciate your help in this.

For nothing ;-)

At one of these days

Capture2.JPGCapture1.JPG

Oops- here are the screen shots.

All right ;-)

Please Login or Register  to view this content.

You are a genius. I wish there was something I could do to repay you for all the help. Thank you sooo much!!!!