Hi
In a cell I need to put a word or some letters so this would triger a search in a column containing about 3000 cells. What I need is that as i am typing the letters, a drop down list to appear with all the cells containing what I typed so I can select the one I needed.
Please note that the letters or word I will put will not necessarily be the first letter or word in the search column.
ie: if I type "house"
the items containing house would be : "Villakil house" , "mount house virmint" etc....
I need these items to be shown in the list so I can select.
I am not sure I need a macro for this or not but I will appreciate your help
Bookmarks