'Predictive' searching in drop down lists

[Mel A]

Sorry, I wasn't sure how to describe this in the title.

I require help with the attached workbook please.

On the 'QUOTE' tab I have an 'Item Select' column in column A. I have added drop down lists to allow for item selection (picks up data from 'ITEMS' tab).

The problem I am having is this....

Many of our items start with the same number i.e. on the attached there are 4 items starting with 2156016.

I was hoping that if I started typing this number into the drop down list field that only the 4 items starting with this number would appear in the drop down list. Unfortunately it doesn't work this way as I had hope and I have to scroll through the drop down list to find the item I require.

Can anyone provide a solution to how I might be able to do this?

Thanks in advance.

Mel