Hello All,
I have a list of data and I would like to creat a dropdown list search engine in another sheet using VBA but am struggling with it. I have attached the file for better understanding. data are inserted in the sheet "Data" and drop down lists are created in sheet "Search". I used the following codes to get the first list running but it's not wotking. can anyone tell me where I am doing it wrong or how should I creat search engine from a dropdown list please?
I really appreciate every single comment and help.
Thanks
Bookmarks