Hi Kevin,

This site should help you..

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

Hope this helps,

Gav.

"kevin" wrote:

in excel i have a coloum F and it starts from F10 to F165 now how do i appile
filters to them all

i want to be able to use just use the drop down for the user to select what
departmet they need and in the drop down their is going to be a list of 17
departments

any ideas