a really small thing but need help.
Have a list of up to 200 entrys with name of my customer and create via Excel Data Validation a dropdown field. The Problem is i can not search and must scroll 200 entrys up and down to find the correct name.
So i need a VBA Solution.
Maybe with Combo.Box.
The best thing would be if user insert "?" in cell and than Popup will open where i can search for my data.
But mabye you have a better solution...
23 freelancers are bidding on average €23 for this job
Hi, Shall provide you with an Excel VBA based solution which will autofill the search cell from the range of 200 entries. Let me know and we can proceed. Regards, Arul
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy