+ Reply to Thread
Results 1 to 4 of 4

Creating An Auto-sorted To Do List

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Creating An Auto-sorted To Do List

    Hey everyone!

    I want to create a task/project list. This will be pretty straightforward, but I'm curious on a certain aspect. I have 5 main categories of work I do, so I want to keep them as separate lists in tabs (at the bottom of the worksheet). However I want a Master List that automatically pulls from the tabs so I can see all the work at a glance, but sorted by A, B, C, D priority.

    I figure I can set the priority on each item as I enter them on their respective tab, but I want the Master List to automagically show everything in order. How do I go about this?

    NOTES:
    Each tab requires the same info per item – Priority, Name, Due date, status, requested by, and project notes.
    I'd like for the Master List to show all the same details, just sorted so I can enter items in each tab and have the Master List update the order on its own.

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Creating An Auto-sorted To Do List

    If someone is able to help with the structure you suggested, great, but I would recommend entering each item into the master list, and having the category tabs pull for the mater tab.
    The attached file shows this type of structure.
    If you feel this would work for your purposes, let me know, and I can customize it for your scenario.
    Attached Files Attached Files
    Last edited by Melvinrobb; 04-29-2013 at 02:59 PM. Reason: Forgot to attach file.
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Creating An Auto-sorted To Do List

    Thanks for reaching back out to me so quickly. I didn't think to have the Master List push to the category lists. It sounds useful, I'm just wondering how inputting new items would be sorted in the Master List.

    For example, in 3 weeks, I'll get say, 15 new projects. Adding them to the bottom of the Master List is not what I envisioned, more the Master List stays ordered by A, B, C, D priorities regardless of when the items were added or due.
    I hope that makes sense.

    If that can be achieved with the spreadsheet you graciously attached, then count me in!

  4. #4
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Creating An Auto-sorted To Do List

    For what you are describing, I would recommend simply having a master list, and use the table features available.
    In the attached file, you can click on the arrow in cell D4 and sort A to Z and immediately have it sorted by Priority.
    You can also filter the table, and only show entries that match a certain category or priority, etc.....

    This is probably a better option that having multiples tables drawing from the original list.

    I have included a tab with the formulas needed to have the master list broken down into categories if desired.
    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)

Tags for this Thread

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