Questions tagged [dropdownlist]

A drop down list is a list with predetermined options that expands when clicked to reveal the options available.

Filter by
Sorted by
Tagged with
0 votes
1 answer
62 views

I want to use the sumifs function with a drop down list to populate data from one sheet to another

I have data in image one which I want to be visible in image two with the use of a drop down list, where the result changes based on which shop is selected from the drop down list. I tried the sumifs ...
-2 votes
1 answer
31 views

Link drop down menu to update automatically cell values when selecting in the menu

I have created a drop-down menu that has all the name of all the tabs other than the one I am working in V1-V10. I am trying to get the linked cells below in the form to update automatically with the ...
0 votes
1 answer
60 views

Not sure what function to use?

I am trying to make a table to do some easier real estate math. I am going to have a drop down list for my categories, and a drop down list for my number of bedrooms. I want Excel to look at the ...
0 votes
1 answer
122 views

How to lookup values from dropdown lists in Excel?

I have a complicated Excel worksheet, but I will simplify what I need in a simple scenario. I have the following sheet as raw data. Also, I have another sheet where I can select the student's name ...
0 votes
1 answer
138 views

Populate rows (year listing) based on drop down selection MS Excel

I have a challenge presented to me. I have searched quite a bit, but I cannot find a solution that exactly works. I have a drop down listing that represents the number of years (1-50). I need to ...
0 votes
1 answer
165 views

VLOOKUP Name Error even after using formula wizard

I'm having a really hard time trying to figure what is wrong in by VLOOKUP formula. I even used the formula wizard to try to fix it. Here is the formula I'm using. =VLOOKUP(A10,Melaminedetails,2,FALSE)...
0 votes
1 answer
191 views

AutoHotKey dropdown list which opens links on ME

Trying to create AutoHotKey with drop down list to open internet links (for company). As I created, noticed errors and mistake, that I cannot fix it. First it runs whole script and I have around 80 ...
0 votes
0 answers
150 views

Excel Drop down filter - How do I add a option to unselect filter and display all data?

Don't know the exact wording, so apologises if title seems confusing. In short I'm doing up a small data input table for my local swimming club whereby they can enter in the raw data of the competing ...
0 votes
2 answers
3k views

Excel Cell Currency Picker

I want to show the currency symbol (as format not text or concat prefix) in a cell which is set as a defaulted "AUD" currency so it'll look like AUD 1,450,000.00 but have that same cell ...
1 vote
1 answer
491 views

Reset Conditional Drop-Down Lists

I hope you can guide me in a query. I am performing a search for several items in the worksheet Dashboard, with information that is recorded in Table1 located in the worksheet "Original data"...
0 votes
1 answer
138 views

How do i create a Dynamic Dropdown Data Validation List based on pre selected criteria?

I seldom use Google Sheets or Excel, but now that I'm working on a card game, I have since thrusted myself into formulas and data validation. I'm currently running into a logic issue. I would like to ...
0 votes
0 answers
144 views

Excell Cell Drop Down Menu randomly lose data when attaching to an email or uploading to Google docs. How to fix?

My employer uses an excel spreadsheet with drop-down menus in some of the cells to keep track of student attendance. When I send the doc via email and upload the doc via Google Drive, sometimes a ...
0 votes
1 answer
75 views

Firefox: URL in URL dropdown, but not in history: can not be deleted

There's a URL in the dropdown menu that I can not find in the history. Usually I can delete a URL from history and it also disappears from the dropdown menu. How can I get rid of this URL?
0 votes
1 answer
346 views

Force selection on previous cell with same dropdown list?

My sheet has multiple cells with the same dropdown list. The data for the dropdown list is also on this sheet (in a hidden column (H)). So the dropdowns source =$H$1:$H$6 A B C D H (data for dropdown)...
0 votes
1 answer
2k views

Add Description in Dropdown List Excel

In a spreadsheet, I saw a dropdown list using data validation as below. As it shows, the value is numerical, namely, 0 or 1. They act as a switch and will be used in formula. However, there are ...
0 votes
1 answer
100 views

Auto-populate data

Tricky problem for me. Is it possible to use a drop-down box (or alternate tool) to select a specific week, then use this to auto-populate data into a larger data table? E.g. step 1 - select week e.g. ...
0 votes
1 answer
2k views

Excel-Drop down list that will change dynamically based on a criteria

I want to create a drop down list that will change dynamically based on a criteria. In the column "Name" the same name can appear more than once. The "Option" value is unique. Now ...
0 votes
1 answer
78 views

Choosing specified cells in a column range and show in dependent excel drop-down list

I want to create a data table (Table3) that col [Member] will fill members name by a drop-down list from the Table1[Mem No] and I want to fill the [book] column of Table3 from the column Table2[books] ...
1 vote
1 answer
67 views

Get a drop-down list from another sheet based on lookup

I have a list of CA in my Source sheet that looks like this: And in my main sheet I need to get a dropdown list of "little a" for each CA, like this: Main sheet: Sheets: For example: ...
2 votes
0 answers
32 views

Is there a quicker way to open a single file in different programs?

This question is asked because I use .Tif files, and need to alternately open them in a photo viewer to quickly see files and an image editor to work on them. It's not an urgent problem, but I notice ...
3 votes
1 answer
993 views

Excel cannot define a List in Data Validation from an existing Table Name and Column

In cell O2 below, I want to propose a drop down list box of values which are defined in the column Group of the table Table2 (this table is located in the columns L and M), but I get a generic error ...
0 votes
2 answers
37 views

drop down list in excel2016

I have created drop down list as per attached image. but the problem is I have long list of same item, the drop down list shows the same item as much as my data contain. is there any solution? As seen ...
0 votes
0 answers
299 views

Excel drop down disappeares after deleting rows

I have created a drop down using data validation list. The issue is that when I delete rows the drop down in my cells also gets deleted. Is there any way tor retain the drop down ? I delete rows ...
0 votes
1 answer
1k views

Create drop-down list based on two other criteria

I have a range of data relating to buildings. The fields are building type, entry into the building, and size of the building. I have created drop-down lists for the building and entry type. I now ...
0 votes
1 answer
187 views

Limit in excel data validation source code

I have an excel file with two sheets. The second sheet (Report) contains data validation cells based on the first sheet (Data). From the second sheet, the drop-down list that displays in the Select ...
1 vote
0 answers
55 views

Users Bypassing Workbook Protections - What Did I overlook?

I created a Excel 2016 workbook that was to be sent to multiple department heads to then be distributed to their personnel to solicit input on a topic. Some of the columns were free response; some ...
0 votes
1 answer
941 views

Dropdown list which depends on active/inactive status of a neighboring cell (Excel 2010)

I'm using Excel 2010 I have a spreadsheet to track my time charging. I have all of the charge numbers in Table1 and I use a drop-down list in another sheet to select the charge code to use for each ...
1 vote
1 answer
729 views

Creating a drop-down list that skips blank reference cells

I would like to create a drop-down list from another worksheet in the same file. The other worksheet has a number of items listed, and some criteria that may exclude the item from being useful in my ...
0 votes
1 answer
4k views

Disable certain drop down list selections based on another cell

Let's say that in column A, users enter in different numbers. In column B, there are options of Y or N. If column A has a cell with the value of zero, it should disable the "N" option in column B. How ...
0 votes
0 answers
121 views

Excel Dropdown List from Range + One Static Value

Id like to create a DropDown list from a Named Range containing all months in the year, but also id like to add a static value at the beginning of the list called "All" im wondering if that's possible!...
0 votes
0 answers
100 views

Excel - Drop down list that allows non-listed values

I'm looking for a way to have a drop-down list based on existing data BUT that allows me to enter values that are not included. Let me picture the situation: I have an evaluation form where we enter ...
1 vote
2 answers
2k views

Excel - Colouring items in dropdown list

I created a dropdown list on excel but I have lots of items in it. I want to categorize the items in that list and make the similar ones appear in the same colour. All I could find so far was how to ...
0 votes
2 answers
122 views

Microsoft Excel 2016 - Need to auto populate cells based on conditional drop down lists

Good afternoon. I am a high school Strength and Conditioning coach and want to provide my athletes with progress reports based on data I keep in a master data sheet. This spread sheet has over 5000 ...
0 votes
0 answers
329 views

Drop down menu but return other values in word

I want to make a dropdown menu in Word but when I choose something, for example "fruit" it should return as "apple". I'm using this to create a form some kind of form for my ...
0 votes
0 answers
416 views

Dynamic dropdown in Excel

Trying to created a searchable dynamic dropdown containing a list of all of our products for order processing at work. It is searchable which is one of the main uses, but it only works for one of the ...
0 votes
2 answers
3k views

Change out column of data using drop down

I'm looking to change out a column of data in my excel spreadsheet with 8760 data points without copy and paste. I'd like to use a drop down menu to select various data set columns in other tabs of ...
0 votes
1 answer
232 views

Choosing a specific drop-down choice that places a cursor in, or highlights, another cell for data entry

In Excel, 2016, I have created a table that includes drop-down selections in some cells. Example table I would like to find a formula that prompts another cell to be highlighted, framed, or have a ...
0 votes
0 answers
298 views

Excel: dropdown list determines how many rows are in a table

I am trying to populate rows based on user selection from a dropdown box. When A3 is selected I would like to have column B populate (inserting the same number of rows + (the total row) as items in ...
0 votes
1 answer
345 views

Value retrieval from the multiple selection dropdown in Excel

I am trying to make calculation from my dropdown menu. I have following dropdown in sheet 1 in my Excel. ## Category ## ### AAA ### ### BBB ### ### CCC ### ### DDD ### In sheet 2, I have ...
0 votes
1 answer
1k views

Data validation in Excel based on value matrix

I'm really struggeling to solve the following task. I have a data matrix where vehicles and features are matched. Now I want to use this as source for Excels input validation feature in a second ...
0 votes
0 answers
530 views

Excel: Filter by Substrings

I have a list of movies in an Excel table. In one column, titled "Genre", the movie genre is shown. A movie can have one, or several genres, separated by commata (and sorted alphabetically): Now, ...
1 vote
1 answer
55 views

Next steps with accessing an Excel table from one sheet into another

I've done it once before, using a web tutorial that I cannot locate again, but now I'm trying to it again and I'd appreciate some insight in terms of “next steps” and where I am going wrong. I have ...
1 vote
1 answer
117 views

Conditional defalt on data validation list

EDIT No. 2 *Ok, my previous articulations of my problem were, as pointed out, pretty rubbish. This edit, rephrases the question in a more straightforward manner, summarises the context and provides ...
0 votes
1 answer
2k views

How to populate a table with data from tables on other sheets using a drop down list

I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions. Example: I ...
1 vote
0 answers
343 views

Display value based from multiple dropdown list with IF, AND, SUMIFS

Attached below I show an example of what I'm trying to achieve Basically I want to have a result based on the chosen item from 2 dropdown list and a range of date. If you select "Name1" "Test 1" and ...
1 vote
0 answers
318 views

Refresh drop down cell value in excel

I have a drop down cell which has a list of values. The problem is, I want to refresh the cell value to the 1st value of the list "JR" or other, whenever the I change the value on the "S235" cell. ...
0 votes
1 answer
1k views

Bat to open webpage, choose from dropdown menu and automatically input proxy login

I'd like to run a bat that opens an specific webpage on Google Chrome, input proxy username and password right after launching the internet browser and pick an option from a dropdown menu. For the ...
0 votes
1 answer
55 views

Excel dropdown with condition

I have searched for a while without being able to find a solution to my problem. A have a table named tbl_lov that contains the list of values used in a dropdown list via indirect function. INDIRECT("...
0 votes
1 answer
1k views

Change dynamically a picture on a worksheet based on a value from a dropdown list

I use Windows 7 Professional and Excel 2013. I would like to change dynamically a picture on a worksheet based on a value from a dropdown list. I found online 2 ways that seems to fit my problem. ...
1 vote
1 answer
3k views

"Link" two cells, modify one changes the other

I have a dataset that I use to generate some graphs. I have a cell in one sheet that changes my data based on the country I choose from a dropdown. I want to be able to change this dropdown from a ...