All Questions
Tagged with list dropdownlist
5 questions
0
votes
1
answer
237
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
423
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
0
votes
1
answer
84
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
80
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: ...
- 13
1
vote
1
answer
148
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 ...
- 121