Drop down box

[John]

hi,

i have a excel sheet that i want to have a drop down box
at the top (in a freezed frame section. When a user
sellects a value in the drop down box the value is
displayed below the freezed frame where its located in the
worksheet. e.g

cell number
'
1 Drop down box located here which user has selected 'tyre'
2____________________________
56 tyre blah blah
57

 

[Frank Kabel]

Hi
have a look at 'Data - Autofilter' for this

 

[john]

Cheers Frank. Works a charm

-----Original Message-----
Hi
have a look at 'Data - Autofilter' for this
.