wfsteadman
New Member
- Joined
- Dec 28, 2016
- Messages
- 15
Greetings all,
I am trying to make a dropdown list for that will be used in cell D# where the # will be the row from say 60 - 90. Meaning I want the dropdown list to be in each of the D cells in rows 60-90. The issue i am trying to solve is how to create the list dynamically based on a couple of criteria
The values for the list will come from cells
B29-33, B37:41, B45:49, B53:57
And at times some of the cells may be blank so I don't want them to show up. Also there could be multiple cells with the same value but I would only like the value to be in the list once.
For example:
B29: port33
B30: port34
B31: port34
B32: port33
B33: BLANK
B37: port31
B38: BLANK
B39: port31
B40: port32
etc...
so in the list I would like it to only have the following options:
port31
port32
port33
port34
This list will be updated based on a worksheet change event.
Any assistance would be appreciated.
Thanks in Advance
Wally
I am trying to make a dropdown list for that will be used in cell D# where the # will be the row from say 60 - 90. Meaning I want the dropdown list to be in each of the D cells in rows 60-90. The issue i am trying to solve is how to create the list dynamically based on a couple of criteria
The values for the list will come from cells
B29-33, B37:41, B45:49, B53:57
And at times some of the cells may be blank so I don't want them to show up. Also there could be multiple cells with the same value but I would only like the value to be in the list once.
For example:
B29: port33
B30: port34
B31: port34
B32: port33
B33: BLANK
B37: port31
B38: BLANK
B39: port31
B40: port32
etc...
so in the list I would like it to only have the following options:
port31
port32
port33
port34
This list will be updated based on a worksheet change event.
Any assistance would be appreciated.
Thanks in Advance
Wally