View Single Post
  #1   Report Post  
BB
 
Posts: n/a
Default Adding entry to validation list without retyping all lists

OK so I have a worksheet with a drop-down list that has the states of the US
listed. In the next column are 50 dependant drop down lists that have various
cities listed, and depending on which state you choose, the drop down list of
that state's cities shows.

Is there any way I can include the option "Other" in the cities column (call
it column B) without going back to my list source (my list is a named range)
and typing in "other" in the lists of each of the 50 states. I am a little
too lazy to do all that if I don't have to.

Thank you for your time