IF 100% Then Task is Done

[joepFIMBLE]

Hi Everyone,

I am trying to create a macro that will Copy and delete all tasks (from a ToDo list) that are 100% done to a diffrent sheet called Done. I'm struggling to search for the 100% value (this column is formatted as percentage).

This is what i have so far:

Please Login or Register  to view this content.

Can anyone help me out?

[Kaper]

Hi,

Two suggestions:

Please Login or Register  to view this content.

The first will help you if you have more than one 100%. Deleting a row shifts all rows below one row up. This is why it is worth having a loop going large->small direction. because all rows below current row were tested before.

The second 100% is just one.

If this value is computed some way, it would be safer to have

Please Login or Register  to view this content.

or may be even :

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[joepFIMBLE]

Tank you Kasper for you help, again!

The mocro works perfectly now, little bid stupid of me to forget to use 1 in stead of 100.. Also the backward loop is a perfect solution, thanks a lot!

[Kaper]

See also solution by sintek
It replaces the loop with the use of autofilter.
If there is a lot of data, such approach will be significantly quicker.

[joepFIMBLE]

Thank you Sintek.

Your solution is actually a lot faster than my loop!

Will use it, thanks

[sintek]

Glad I could contribute...Tx for rep +