• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Todo list

Bosse

New Member
Hello!


I'm a newbie so please....


The "Todo List Application" look for the condition "DONE" per row in column B and remove all rows and copy them to "Finished todo items" worksheet at the end and timestamped.


It is a bit slow, I guess becuase it going trough all rows in the defined area (row 103). Else it works fine, my questions is:


1) Is it possible to make it faster by using rows count, i.e. .End(xlUp)?

Please show an example howto implement that in the "Todo List Application"


2) It's only moving items from one column, how can I extend the range to several columns? Please show an example howto implement that in the "Todo List Application"


Yours faithfully,


Bo
 
@Bosse... I guess you are talking about the project management templates' todo list app. I will get back to you with a solution soon. But on preliminary inspection, I can see that the macro only processes 100 rows and cannot be all that slow...
 
Back
Top