Automatically populate lists from master list/ Create Teux Deux or Trello Style lists
Results 1 to 8 of 8

Thread: Automatically populate lists from master list/ Create Teux Deux or Trello Style lists
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2009
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    I have one long list of tasks in an excel sheet with columns for task, date due, project & priority etc. I have macro buttons to sort by each column and generally it works well and is simple but I would like to be able to view it in a similar way to this: https://teuxdeux.com/ or Trello ie, have a row of consecutive dates and then the tasks for that day listed below the dates so you can get an 'at a glance' look at the week.

    I was thinking a vlookup may work but seems a bit clunky, is there a simpler way?

    Thank you!

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,732
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Help - how do I automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    Hi & welcome to MrExcel.
    I think you'll struggle to find anything "simpler" than a Vlookup.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Oct 2009
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help - how do I automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    Hmm well that didn't actually work as I have multiple tasks on any given date.

    I have tried to follow this and haven't got it to work yet but is this the right idea? https://www.exceltactics.com/make-fi...l-using-small/

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,732
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Help - how do I automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    Without any idea of what your data looks like, or exactly how you want to display it, it's difficult to tell.
    Can you post a small sample of your data & what you want as an end result?
    There are some add-ins available here that enable you to post data to the board. https://www.mrexcel.com/forum/about-...tachments.html
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #5
    New Member
    Join Date
    Oct 2009
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help - how do I automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    I am currently on a mac (although trying to do this on a work Windows computer) and can't get the add ins to work but these are my two sheets.

    The first is my list which is where I update the data
    The second I want to just extract automatically from the list and show it in columns

    https://ibb.co/P6csdSf
    https://ibb.co/VW8mG9p

    Thanks for your help

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,732
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Help - how do I automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    Ok, as you have multiple matches Vlookup won't work.
    Try
    ABCDEF
    219/08/201920/08/201921/08/201922/08/201923/08/201924/08/2019
    3Task1Task2Task7Task9
    4Task3Task8
    5Task4
    6Task5
    7Task6
    8

    Sheet2



    Worksheet Formulas
    CellFormula
    A3=IFERROR(INDEX(Sheet1!$D$3:$D$11,AGGREGATE(15,6,(ROW(Sheet1!$D$3:$D$11)-ROW(Sheet1!$D$3)+1)/(Sheet1!$B$3:$B$11=A$2),ROWS($A$1:$A1))),"")



    Copied down & across
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  7. #7
    New Member
    Join Date
    Oct 2009
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help - how do I automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    It works!

    Thank you!

  8. #8
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,732
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Help - how do I automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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