LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation - Dropdown List Not Appearing MWS Excel Discussion (Misc queries) 2 April 25th 05 05:05 PM
Auto Update A Validation List Dmorri254 Excel Worksheet Functions 2 March 3rd 05 07:29 PM
Refresh a Validation List? jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 05:48 PM
Validation List and VLookup are ackting strange Jasper Excel Worksheet Functions 1 January 24th 05 01:49 PM
list validation using list validation... Patrick G Excel Worksheet Functions 1 December 21st 04 12:37 AM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"