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
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,975
Office Version
  1. 365
Platform
  1. 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
6,975
Office Version
  1. 365
Platform
  1. 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

ADVERTISEMENT

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top