Gathering data from worksheet
 

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

Gathering data from worksheet
 

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

Gathering data from worksheet
 

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

Boss

"whatzzup" wrote:

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

Gathering data from worksheet
 

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

"Boss" wrote:

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

Boss

"whatzzup" wrote:

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