....actually, i just tested my last theory and that's definitely your
problem...you need to hard code the ranges......maybe even hard code a larger
range to allow you to input new items in your existing list without having to
change it each time.
good luck
"paige" wrote:
also....this may be reaching, but all together possible...
is your named range hardcoded ($) so that each cell that is formatted with
data/validation refers to the same cells each time?
for example, range =$A$1:$A$4
"Davida" wrote:
I'm referencing the values in a range in my workbook. For example, the list
contains text such as
noodles
chips
salad
Once I choose noodles, it's gone from the list of choices.
Thank you for your time
"paige" wrote:
interesting...because this is not how drop down lists work.....
question: when you created the list, did you hard code the values or are you
referencing the values in some range in your workbook?
"Davida" wrote:
I created a drop down list in excel, however it only allows me to choose each
item only once and then it's gone from the list. I need to be able to choose
each item multiple times.
|