searchable

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior: 1. The combobox can appear and hide by certain action e.g...

HI All, I found some VBA which created a searchable drop-down menu after double-clicking which worked perfectly fine however now when I use it the drop-down appears I then select the entry and then rather than populating the cell it goes totally blank. Please can someone help me. I have no idea...

First off, I'm open to a variety of solutions for this situation. I'm currently working on using excel to make a searchable database of documents. I'm hyperlinking the articles, and have some advanced filter settings right now. I'm making a column that contains keywords that relate to the...

Hi, I currently have an Excel spreadsheet that has multiple tabs and I am trying to find a way to make the first page be a search page that includes the tabs as searchable. So, for example, lets say each tab is named different states and then there is data in those worksheets from those states...

Hi, I'm looking to create a searchable dropdown list in each cell of a calendar, for 10 classes, roughly 2000 dropdowns. At the moment I have non-searchable dropdowns in each cell, which means scrolling a long list of lessons to find the correct one - it would be much easier if I could type...

Hi, I watched a tutorial and tweaked my formula to make drop down lists in all cells searchable, rather than just 1x searchable drop list in cell F5 on the Forecast sheet. I changed the formula from, =IF(ISNUMBER(SEARCH('Forecast'!$F$5;'Master data'!C2));MAX($D$1:D1)+1;0) to...

need to create a searchable database for website which has lot of photos please help me ASAP thanks

Hi everyone. I have been trying to help myself as much as I can, however, I have spent too much time on this and now I am rushing to get it done which is making it worse. What I am trying to accomplish is to be able to enter/select a category which will limit the service list to the items...

Hi Guys, How do you create searchable drop down list as seen on google sheets? I have excel 2016. I want to use the drop down to complete a column in a table. I know I have to use data validation. Thank you.

Hey guys, So I have a sheet that has a list of items (A5 through A20,000, approx). Column B is for unit prices but they are not filled in. I want to populate this column for only specific items (as we only use maybe 100-200 of the 20,000). Is there a way to use a searchable drop down box to...

I do a lot of quotes for much the same materials in an almost infinite variety of configurations. I have series of metrics that I calculate in every quote I do. I'd like to be able to write these values to a separate file to create a running record of my pricing. And continue to add records...

Create multiple searchable drown. I only got one searchable dropdown list of teams

Hello Everyone, I just made excel searchable drop down by using active x control (Combo Box) and it's working fine But to select the drop down value i have to use Mouse , however i want to select the drop down value by arrow keys. is it possible? Please help

When I do VLOOKUP from another sheet, the resulting data is not searchable to the current sheet where I have the VLOOKUP formula. Why is this and what's the workaround? Please help.

Ok So I have a two separate worksheets. 1. contains the list for my dropdowns 2. contains the dropdowns for my users to choose from one list has 1975 names the other has 1417 names on the user worksheet where I user data validation to create dropdowns which contain the list from the first...