filtered data validation

Hi everybody, i will describe my problem:
I have a list of streets on one column (different sheet) and i'd love to give my users the possibility to choose a street based on whatever they write in a cell. a kind of dynamic data validation...
I will try to explain myself better with an example:


i have this list of streets:
streets
high street
republic street
bond road
fullend street
nice street
endington street
all high street

a user would write "high" in a cell and press the data validation arrow, at that point only
high street
all high street
would be displayed.


is it possible? i was thinking about a range filtered right before the click on the arrow or something like that

i appreciate your help. thanks in advance

Hi Gotrekk,

I suggest you attach your workbook so we can help you with that one.

Regards,
thisisgerald

Hi

See if my example, helps you.

@Gotrekk,

I'm currently working with this and it's giving me a challenge.
I'm only having problem because I can use the autocomplete on the streets sheet and not on the main sheet.

Regards,
thisisgerald