+ Reply to Thread
Results 1 to 4 of 4

Help me clean up my task list

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    san francisco
    MS-Off Ver
    Excel 2003
    Posts
    11

    Help me clean up my task list

    hello everyone, i just wanted to post a task-list that I wanted cleaned up a bit. it does everything that i want, but it seems to be a bit buggy and i thought i could get some help.
    --when i click the "clear completed" button, it only clears about 70% of the completed. I then have to click clear 2 more times to get rid of the rest.
    --i have to have my G1 cell filled in the "archived tasks" sheet filled with something in order for the archived tasks to insert the completed tasks in a new row.
    --i would like the completed tasks to be inserted newest at the top and then oldest at the bottom instead of vice versa.
    -- when a new row is inserted, id like for the row to clear the formatting of weird stuff like the bolding, grey fill etc, in a simple way rather then telling excel step by step to "1. change color of cell, 2. unbold 3. borders" etc...

    i worked on this forever as its really hard to piece together code that is kinda what you need, but not really. but id also like to just see how it could have been done neatly.

    any help would be great!
    Attached Files Attached Files

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Help me clean up my task list

    Try this and see if it does what you need. Click the same button as would for your old macro.
    Attached Files Attached Files
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Registered User
    Join Date
    06-25-2012
    Location
    san francisco
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Help me clean up my task list

    thanks for the help. it looks good but the issue is that i can clear it the first time it clears perfectly; but the second time it overwrites the old archived tasks. ostensibly it would push down the old tasks and archive the newer tasks on the top... its a better method though of clearing the old tasks for sure, so I will see if I can modify!

  4. #4
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Help me clean up my task list

    Try this one instead.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1