Searchable Drop Down List

[Chewyhairball]

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.

 

[Akuini]

Is this adaptable for my needs or do you have a better alternative I could use.

I created a searchable combobox that has 2 special behavior:
1. The combobox can appear and hide automatically when you select a cell in a certain range.
2. You can type keyword in the combobox and the list will be narrowed down as you type.

You can find an example here:

Best way to create a searchable drop-down list with auto-complete functionality to cells in a column?

Hi Folks, I have a time-sheet workbook with two worksheets (ws). In sheet 1 (the time-sheet ws), Column A is "Employee". Time-sheet worksheet. Employee Start time Finish time Hours worked Joe Blogs Jane Doe I wish to be able to start typing a different employee on each row...

www.mrexcel.com

Note:
In sheet2 in the example workbook you can find a slightly different setting from the one in sheet1.

 

[jasonb75]

Reading the link that you provided, what you want is already appearing in column H, so you just need to copy that to column B.

 

[Chewyhairball]

I created a searchable combobox that has 2 special behavior:
1. The combobox can appear and hide automatically when you select a cell in a certain range.
2. You can type keyword in the combobox and the list will be narrowed down as you type.

You can find an example here:

Best way to create a searchable drop-down list with auto-complete functionality to cells in a column?

Hi Folks, I have a time-sheet workbook with two worksheets (ws). In sheet 1 (the time-sheet ws), Column A is "Employee". Time-sheet worksheet. Employee Start time Finish time Hours worked Joe Blogs Jane Doe I wish to be able to start typing a different employee on each row...

www.mrexcel.com

Note:
In sheet2 in the example workbook you can find a slightly different setting from the one in sheet1.

Thank you. This looks ideal. I cant access the link to download this file at work though...

 

[Chewyhairball]

Reading the link that you provided, what you want is already appearing in column H, so you just need to copy that to column B.

Hi

I am not sure I follow what you mean?

 

[jasonb75]

With the example, type 'i' into the search box, then look at column H.

 

[Chewyhairball]

With the example, type 'i' into the search box, then look at column H.

Hi

That's fine and when I select it it populates cell B3. What I would like it to do though is do another search and populate B4, then B5 etc

Rory

 

[Akuini]

Thank you. This looks ideal. I cant access the link to download this file at work though...

Unfortunately we cannot attach files in this forum. But I guess you can download it from your computer at home?

 

[Chewyhairball]

Hi
Yes, I can do that. I tried to download it to my phone and then send it onto my work email but that didn't work.
If you have a written version on it that would be good but if not then please don't go out of your way to make one.

thanks

Rory

 

[jasonb75]

That's fine and when I select it it populates cell B3. What I would like it to do though is do another search and populate B4, then B5 etc

I misunderstood what you wanted there, being formula based I don't think that the trump excel method will work for what you want.