Please refer the below link by Debra Dalgleish

on the subject "Excel -- Data Validation -- Dependent Dropdowns from a
Sorted List "

http://www.contextures.com/xlDataVal13.html

If this post helps click Yes
---------------
Jacob Skaria


"Lynda" wrote:

How can I create a drop down list that also lets me filter information?
ie product sales for a particular venue. The list contains all venues but
when one is selected it shows only the information on the spreadsheet for
this one and I can choose select all to view all others.
I have done this before but was so long ago I cant remember. Any help
apreciated x