Questions tagged [dropdownlist]
A drop down list is a list with predetermined options that expands when clicked to reveal the options available.
59
questions
0
votes
0
answers
63
views
Issues using snipping tool to attempt to grab items from a drop down menu
Snipping tool max delay set at 5 seconds and confirmed. Then I open (right click) my Windows 10 explorer on a desktop folder the drop down menu (many items) shows, but if I do anything to copy it the ...
0
votes
0
answers
19
views
Switching or changing Sheets using a drop down that has date ranges for the data
I can't seem to figure out why this doesn't work. When I choose the drop down selection that should activate or trigger the vba code, nothing happens. I have the below code under Sheet1 which is ...
0
votes
1
answer
83
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 ...
- 1
-2
votes
1
answer
44
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 ...
- 1
0
votes
1
answer
199
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 ...
- 7
0
votes
1
answer
192
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 ...
- 1
0
votes
1
answer
330
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)...
- 1
0
votes
1
answer
218
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 ...
- 1
0
votes
0
answers
191
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 ...
- 101
1
vote
1
answer
547
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
163
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
163
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
86
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
390
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)...
- 5