Gathering data from worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Apply reference from B2 to A1, then press F2 nad to freez teh link press F4,
copy down the formula..
Hope u gotit.

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