In Sheet2 column A languages has to be entered through drop down list but if I want to choose "Turkish" from drop down I need to scroll down until "T" letter comes, is there any possibility to search with letters and shows the match cases suggestions in the drop down list. Like if enter "T" it shows all languages having T...
please find the attachment and please do the needful...
This can't be done with native Excel functionality.
Are you requiring some other alternative, or what? I can see a few examples of achieving this using forms and VBA (googling), but I not sure you'd want that.
I've added a few helper columns (F/G/H), which you can unhide if you like, and inserted a combobox into the sheet (over C3). There is Worksheet code to control the source for the combobox ... right-click the tab and choose View Code to see the code.
Thanks for replying its working great ...
But i need as dynamic and i want drop down list in any particular column, can you review once ....
Please find the attachment.
Thank you so much....
Am having another quiery can you please review once............
COUNT AND SUM FUNCTION BY DIALY, WEEKLY AND MONTHLY
I didn't see a new attachment, but I've tweaked my example to work on a range ... look at the Worksheet code, it does a lot more now.
TTTT v2.xlsm
I guess your attachment was the screenshot?
I've had a quick go at your problems ... have a look. In your summary sheets I've marked areas that make no sense.
NEW DPR v2.xlsm
Don’t have an account yet? Register yourself now and be a part of our community!
