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

On 4 Oct, 22:53, LP_Nick <LP_N...@discussions.microsoft.com> 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