Autofilling Lists based on prior list choices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide subsequent rows based on pull down list choice - macro 1
Drop Down List Showing Two Cells Info 1
Data validation list drop-down values based on prior selections 2
Selection based on partial input 1
Drop Down List - Other Cell Results 5
list items from one table in another table based on value in first table 2
automatic data fill , based on list into dynamic range 1
Event Procedure - Pick List Choice Unhides Worksheet 9

Back
Top