Good. 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.
