| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilling Lists based on prior list choices
Hello-
Attempting to have 3 lists, the last two's options are dictated by the 1st list. IE: First list is state. MO,IL,VA,OR ect. Now.. you choose OR, list two for 'addresses' will only list addresses that are in OR, then list 3 zipcode.. ect. Just can't think of a way to do it, a clean way that is. Any ideas please let me know |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilling Lists based on prior list choices
On 4 Oct, 22:53, LP_Nick wrote:
Hello- Attempting to have 3 lists, the last two's options are dictated by the 1st list. IE: First list is state. MO,IL,VA,OR ect. Now.. you choose OR, list two for 'addresses' will only list addresses that are in OR, then list 3 zipcode.. ect. Just can't think of a way to do it, a clean way that is. Any ideas please let me know Hi Rather than me repeating what's written elsewhere, take a look at this excellent article: http://www.contextures.com/xlDataVal02.html Regards Andrew Richards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Dependent lists based on the same list | Excel Worksheet Functions | |||
| Multiple choices from lists of valid data | Excel Discussion (Misc queries) | |||
| how do I generate lists in worksheets based on a master list works | Excel Worksheet Functions | |||
| Different Dependent Lists, based on value of first list | Excel Programming | |||
| Filling out list based on other lists | Excel Discussion (Misc queries) | |||
Linear Mode
