Dear Experts
In attached sample file, in sheet Portfolio Column A, I have a drop down .
It is difficult to search thousands of entries and select from the drop down.
How to modify this drop down to auto complete drop down so that I can start typing to filter and select the data that I need
Request help please
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Attached is an example that I have described previously in this forum.
Start typing in your name and the list is filtered according to that search string.
eg. Type in 'John' and the filter will give you all Johns, Johnsons, etc in your dropdown.
No VBA required.
Last edited by Croweater; 02-20-2021 at 07:02 PM.
If I click in Column B, it starts deleing. I guess I need to type in B2 but it does filter
Last edited by grcshekar; 02-21-2021 at 12:28 AM.
Column B was just an afterthought to demonstrate using the name after you've selected it.
As it says 'click below to record the NAME CHOSEN'. If the name chosen is blank, and you click in column B, it replaces any name already there with blank.
But that's not the point is it? The filter box for dropdown is in B2 and the name list is in column D. Forget the rest of column B for whatever you want to do.
Thank You very much
No worries. Hope it works for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks