How to Create Dynamic Drop Down List in Excel Using 4 Different Methods
This video talks about "How to create a dynamic drop down list in Excel" which gets automatically updated when any new values added to the source data. There are plenty of ways doing this in Excel without using VBA and, in this tutorial, we've talked about the 4 different methods to create the Dynamic Data Validation List.
A Dynamic (Advanced) Drop Down List in Excel is more convenient way of selecting data, without making any changes to the source.
In other words, If user updates the list frequently which he will take for drop down list, he must need to modify the data validation every time in order to get the updated drop down list.
But this is where Dynamic Drop Down List comes into the picture and it is one of the best option to select data without making any changes in the data validation. It is very similar as the normal data validation. However, when you update the list, the dynamic drop down list changes to accommodate that action, whereas the normal drop down list does not.
This video explores following 4 different methods to create "Dynamic Drop Down List" ..
1) Table Name with INDIRECT function
2) Table Name as named range
3) OFFSET & COUNTA functions direct
4) OFFSET & COUNTA functions as named range
Visit us for daily dose of Excel Tips & Tricks at http://www.exceltip.com/
In case of any simple or complicated "Excel" query, you can ask to our experts for instant solution at http://www.excelforum.com/