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

[han]

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!

 

[Fluff]

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.

 

[han]

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-filtered-list-sub-arrays-excel-using-small/

 

[Fluff]

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-board/508133-attachments.html

 

[han]

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

[TABLE="width: 810"]
<colgroup><col width="87" span="3" style="width: 65pt;"><col width="375" style="width: 281pt;"><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]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[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 375"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your help

 

[Fluff]

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

Book1
	A	B	C	D	E	F
2	19/08/2019	20/08/2019	21/08/2019	22/08/2019	23/08/2019	24/08/2019
3			Task1	Task2	Task7	Task9
4				Task3	Task8
5				Task4
6				Task5
7				Task6
8
Sheet2

Cell Formulas
Range	Formula
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

 

[han]

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

It works!

Thank you!

 

[Fluff]

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