Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
Hi Guys
I have found this very cool sheet that will ‘almost’ fit my needs perfectly from trump excel. I have attached a link as I am at work and cannot attach an extract of the downloaded example from here.
Searchable Drop Down List
If you start typing in the combo box the names from the list appear in the selection. The thing I like about it is if you type ‘x’ then any words with x such as mexico appear. It is basically like a google search bar.
The word you select then appears in cell B3.
What I would actually like is to be able to have the same sort of search but to be able to put into B3, B4, B5, B6 etc….
I have a large list of data and to save people scrolling down to select what they want or typing in exactly what is required the above is perfect…except it only does it in one cell.
Is this adaptable for my needs or do you have a better alternative I could use.
Thanks for any help with this.
I have found this very cool sheet that will ‘almost’ fit my needs perfectly from trump excel. I have attached a link as I am at work and cannot attach an extract of the downloaded example from here.
Searchable Drop Down List
If you start typing in the combo box the names from the list appear in the selection. The thing I like about it is if you type ‘x’ then any words with x such as mexico appear. It is basically like a google search bar.
The word you select then appears in cell B3.
What I would actually like is to be able to have the same sort of search but to be able to put into B3, B4, B5, B6 etc….
I have a large list of data and to save people scrolling down to select what they want or typing in exactly what is required the above is perfect…except it only does it in one cell.
Is this adaptable for my needs or do you have a better alternative I could use.
Thanks for any help with this.