How to create dynamic dropdown list ? Let's say you add new data to your source, and your dropdown list is updated automatically.
Magic? No, just a Table and the INDIRECT function and the job is done? So you can use this solution with with all the Excel version since Excel 2007
You can try to do this example online https://www.excel-exercise.com/projec...
00:00 Introduction
00:23 Create a standard dropdown list
00:59 Add your data in a Table
01:27 Linking Table
02:16 Use the INDIRECT function
Watch video How to Create Dynamic Dropdown list with a Table in Excel online without registration, duration hours minute second in high quality. This video was added by user Excel Exercice 08 January 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 43,848 once and liked it 301 people.