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

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