You can use an AutoFilter (DataFilterAutoFilter). There are
instructions in Excel's Help files, and he

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


Jon wrote:
I know how to make a drop down through validation. I need to know how to make
a single cell be able to have a dropdown list while still leaving the title
there. The drop down lists will be at the top of columns of info. I already
have a macro that will sort the info, now Ijust need a drop down list that
will leave the title of column but be able to choose from information within
that column.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html