Gathering data from worksheet

W

whatzzup

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
 
R

RagDyeR

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!
=====================================================

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
 
B

Boss

Apply reference from B2 to A1, then press F2 nad to freez teh link press F4,
copy down the formula..
Hope u gotit.

Boss
 
W

whatzzup

Boss, thanks for the reply, trouble i dont understand what you are saying,
could you please expand, i am really sorry.
 
Top