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
0answers
18 views

Varying Chart Range Based on Drop Down Lists

I'm hoping to get some help with automatically updating the chart range in Excel based on what's selected in a drop down list. I have 3 selections for my drop down list: All, Alberta and Saskatchewan....
0
votes
0answers
20 views

Excel drop down list

In excel, I am trying to create sheets that grab data from the master sheet based on which drop down is selected in the master sheet. Example would be I have monthly stats sheets. On those monthly ...
0
votes
0answers
6 views

Skype for Business dropdown box scaling issue

In Skype for Business 2016 > Options > Audio Device, the dropdown box height is too small, hiding the text inside. See attached screen shot. Skype4B options screen shot I had a similar issue in ...
0
votes
0answers
4 views

Ghost-image autocomplete dropdown list [migrated]

I have used VBA to create auto-complete dropdown list : When I share the workbook (Protect and Share) and try to make entries using the auto-complete dropdown lists, a mysterious box (?appeared as ...
0
votes
2answers
32 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
0answers
17 views

Google Sheets, dropdown list and data extracting

How can I realize next logic via Google Sheets? I've created a big table with lots of tabs where every tab named after some country and data in this tab is list of cities of this country with ...
0
votes
0answers
30 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
1answer
66 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
1answer
45 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 ...
1
vote
0answers
19 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). Its not an urgent problem, but I ...
0
votes
1answer
60 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
0answers
138 views

Excel drop down with text values which on selection will display an icon set

I would like to have a column of cells each with a drop-down displaying the text values of "Yes" and "No". On selection of "Yes" a tick icon will appear only [not the accompanying "Yes" text] and on ...
0
votes
0answers
37 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
1answer
72 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
1answer
758 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
0answers
172 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
0answers
155 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
1answer
385 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
1answer
37 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
1answer
519 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
1answer
31 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 ...
2
votes
0answers
110 views

Why are form field suggestions out of position in Chrome? [closed]

For a year or more I've had a problem with Chrome, always on the latest versions, where the suggestions dropdown is out of position. I've reset Chrome. I've disabled all extensions. Nothing resolves ...
1
vote
1answer
44 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 ...
0
votes
1answer
397 views

Autohotkey 5-Level cascading menu

Can anybody who knows Autohotkey pls help me create a 5-level cascading menu (or at least tell me where can I find a ready-made template). See sample screenshot (diagram): The menu should work like ...
0
votes
2answers
110 views

Change an excel drop down value based on selections in other drop downs

I am trying to create a template for Risk Analysis Matrix. I have 3 drop downs in 3 columns: Column A Called "Risk Severity" with values (ACCEPTABLE, TOLERABLE,UNDESIRABLE,INTOLERABLE). Column B ...
0
votes
1answer
229 views

Create Excel chart with two y-axes: constant data on axis 1, dropdown list data on axis 2?

Comfortable with adding a second axis to, and just learned how to use a drop-down list with, an Excel chart. Can't find anything about doing both at the same time. My example: Calendar dates (or ...
0
votes
1answer
331 views

Bind dropdown with the values from 2 cells in another worksheet

I have dropdown contorl in sheet1. Then in sheet2 the values like, 'D2' value 2010, 'D3' value 2020. So now, I want to populate this dropdownlist with values 2010,2011,2012,,,,2019,2020(on workbook ...
0
votes
1answer
72 views

Create a dropdown list with a single dependant variable in the 2nd column

I've created a dropdown list of different type's of lamp fittings, I created a 2nd dropdown list with different lamp wattages. I want to setup my Excel dashboard so that if you select a lamp fitting ...
1
vote
1answer
7k views

Name manager doesn't allow spaces in EXCEL

I am creating dependent drop down list in Excel using Data validation and Name Manager and the function Indirect. My problem is that the Name Manager doesn't allow to have space when defining a new ...
0
votes
0answers
368 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 ...