Home > Forum Home > Analyzing Corporate Financial Data > Reporting using a drop down list from a preconceived table. > Drop down control cell Share

Drop down control cell

Excel Help for Drop Down Control Cell in Analyzing Corporate Financial Data

Forum TopicLogin

Drop Down Control Cell

Rate this:
(3/5 from 1 vote)
HappyGood.  Another tip is to have the list of names in a separate sheet.  This should drive the contents of the drop down menu control.  In the same sheet, you can dedicate a cell for the control cell which will give the index number of the selected name in the drop down.  This cell can in turn populate another cell with the name chosen by using the INDEX function. 

A simple VBA macro can be recorded to do the filter.  This macro can then be modified to capture the name chosen in the drop down menu from the cell with the name and then the macro can be attached to the drop down menu "onchange" event.  This way, when the user chooses the name in the drop down menu, the filtering automatically takes place along with any other data manipulation tasks that were recorded in the original macro.

I hope this helps.
 Excel Business Forums Administrator
 Posted by on
View Full Post

Find relevant Excel templates and add-ins for Drop down control cell in the