I have a Named List (say City_List in cells A1:A10)
Number of Cities listed under this list is variable (max of 10)
I use this 'City_List' to validate other cells. (Data/Validation/List)
When I have fewer ( <10 )cities listed, my validation dropdown box shows blank entries.
I want the dropdown list to grow or shrink as the list changes.
How do I do this ?
Thanks
- sam
Number of Cities listed under this list is variable (max of 10)
I use this 'City_List' to validate other cells. (Data/Validation/List)
When I have fewer ( <10 )cities listed, my validation dropdown box shows blank entries.
I want the dropdown list to grow or shrink as the list changes.
How do I do this ?
Thanks
- sam