Hi there,

I tried to find a solution to my problem but couldn't find exactly what I
was looking for so I thought I would post it. :)

What I would like to do is have a user pick an area from a drop down list
(say in cell A1), and then, once the item has been selected, have the list of
programs for that area appear from A5 to A'x' depending on how many programs
there are for that area.

Is this possible??

I have a separate tab set up with a named ranges for AREA and PROGRAM and I
have my drop down menu working fine with the data validation for AREA.

Basically my lists look something like this

AREA List PROGRAM List
AREA 1 AREA 1 PROGRAM 1
AREA 2 AREA 1 PROGRAM 2
AREA 3 AREA 1 PROGRAM 3
AREA 2 PROGRAM 1
AREA 2 PROGRAM 2
AREA 3 PROGRAM 1

If someone could help me out, that would be great!

Thanks in advance!!

--
TT