How can i filter a list as i type.

[Deanobey]

Hello All, hope everyone is well.

We have a report that we use on a daily basis. In this report we use a drop down list to select 1 store from about 400.

Is there anyway instead of having to scroll through the 400 stores to get the 1 I want, I can start to type the name of the store in the cell and it will filter from the list only stores that start with those letters.

For example:

I type Br and it will then list Bristol, Bracknell, Bridgend etc.......

Please help, this would save me a load of time.

Thanks in advance

[NBVC]

A couple of options:

http://www.ozgrid.com/Excel/autocomplete-validation.htm

and

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