Validation Data

E

ED

How do I add to my drop down list? And how to I create a box to update my
drop down lists<
 
D

DCSwearingen

I am relatively new to this myself.

From what I have read, the list must be in the same worksheet. I
usually put my lists in row one as a horizontal list. Since a
worksheet can have 256 columns, this gives room for a fairly large
list, or several smaller lists. I have used as many as three rows for
my lists. I then hide that row or those rows.

For instance I will use the list $A$1:$Z$1 even though I myght only
have 15 items in the list. Then I can add up to 9 more without having
to change the list reference.

I hope this helps?
 
E

ED

Thank you that worked. The only thing is, when I open my drop down list its
displayed empty and I have to scroll up to see my list.
I have also seen a validation box besides the list to update the list, do
you know how to add this box?
Thank you for your help.
 
Top