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