Results 1 to 3 of 3

Thread: Sort and Move

  1. #1

    Sort and Move



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to create a live list of all incomplete from my current excel file. Each week is a new tab such as Week of Feb 6, Week of Feb 13, Week of Feb 20 and so on. Each of these tab has a running list of task that will be marked as open or close. The goal is to have all the task that are marked as open appear in a separate named "Open Items".
    How could I program my excel sheet to create live list of all the items marked as "Open"? I have tried using and if statement, but I can't figure out how to move the entire row to the "Open Items" tab.
    Thank You

    I have an image of my sheet, but I am not yet allowed to attach images to my post.

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    679
    Articles
    0
    Quote Originally Posted by josht50m View Post
    I have an image of my sheet, but I am not yet allowed to attach images to my post.
    You should be able to post a sample of your workbook, which will asist us

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,032
    Articles
    0
    Potential responders could make some money on this at freelancers https://www.freelancer.com/projects/...pert-13138029/
    were it not for the fact that there is already a solution at http://stackoverflow.com/questions/4...-task-in-excel

    Cross posted without links

    josht50m, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

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