Creating dynamic list in shapes

Anup04

New Member
Joined
Mar 15, 2019
Messages
6
Is there any way to create a dynamic list in shapes?
For eg. I have a table with follow up dates against the companies. I want to insert a to do list in the dashboard where the user can select a date and he can view the list of companies that needs to be followed up with on the given date. I am basically looking to insert the to do list in shapes but cannot find any way to display multiple entries in the same. It only displays the first entry.

Any way this can be done? Any other ideas to display the information on the dashboard is most welcome as I am trying and exploring different options for my dashboard.

Thanks in advance
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
4,641
Office Version
365
Platform
Windows
Are you trying to do this by formula? Is the value in the shape assigned with formula like =C2

If so..., assign the shape value with =C2 and ...

Place formula below in cell C2 - the 3 cells are listed on separate line in the shape
=B2&CHAR(10)&B3&CHAR(10)&B4

If you have Excel365 then use TEXTJOIN
With formula below in C2 - each item in the range appears on a separate line
=TEXTJOIN(CHAR(10),TRUE,B2:B14)

Create a (single column) dynamic named range and the same applies with this formula in C2
=TEXTJOIN(CHAR(10),TRUE,myDynamicList)


The method is the same - concatnate the string in cell C2 using CHAR(10) as line break and assign value in C2 to the shape
 
Last edited:

Anup04

New Member
Joined
Mar 15, 2019
Messages
6
Yes, i am trying to do this by formula. The method suggested by you is what i am doing already. However, the catch over here is that i do not have the data in cell B2, B3 and B4. The data is dynamic and the number of entries can vary. I will explain my requirement in detail below,

I have a DSR sheet with Company names in Column A and follow up dates in Column B. In the other sheet Dashboard, i have inserted a shape and drop down list to display the dates. Whenever the user selects any particular date then the shape should populate the list of Companies to be followed up on that date in the shape that is provided in the sheet.

Alternatively I can do this by inserting a Pivot table showing the Company names and providing a slicer to the user to select dates, that way the pivot table will show the list. However, i wanted to use shapes for this. Please suggest if this can be done.

Let me know if i am clear with my question.

Thank you in advance.

P.S: I am using Excel 2013.
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
4,641
Office Version
365
Platform
Windows
The TEXTJOIN solution suggested above would achieve exactly what you want. But unfortunately TEXTJOIN is not available in your current version :cry:
We need to figure out an alternative way to create the single string required (ie your dynamic list delimited by CHAR(10) )
Are you wanting to avoid VBA ?
 

Anup04

New Member
Joined
Mar 15, 2019
Messages
6
Yes I want to avoid VBA. Also any other method of displaying this to do list in dashboard can be looked into.
 

Anup04

New Member
Joined
Mar 15, 2019
Messages
6
Noted. Many thanks for your help. Will check I i can upgrade so that would be able to use the textjoin function.
 

Forum statistics

Threads
1,081,680
Messages
5,360,498
Members
400,588
Latest member
SpannersWatson

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top