View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
whatzzup whatzzup is offline
external usenet poster
 
Posts: 50
Default 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