Check out this web page of Debra Dalgleish about Dependent lists:

http://www.contextures.com/xlDataVal02.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"whatzzup" wrote in message
...
Good day, i currently have a worksheet with dropdown table and some values
that i am trying to get in an hierachical type sheet where i have a parent
and children relationship,if i place a parent in cell A1, all its children
will appear in b2,b3,b4 and so on. Then i can select b4 the child and all
its
children would appear in c5,c6,c7 and so on. I am not sure if this explain
it
better.
I still dont know how to create the relationship and call b2,b3,b4 from the
info in a1, maybe someone can help.

That would be very well apreaciated......thanks all