logic connection node

[jimraynor]

Hello, I have a very complex problem. The first sheet contains two columns: the first column reports the information of the parent node, the second column report the information of the child's node. I would like to be able to create a sort of "family tree" with the cell architecture shown in the "Connection logic" sheet of the attached example.

I put the smart art graph just for ease of reading but I would only be interested in the layout of the cells.

Thanks in advance

[jimraynor]

I try to explain but I think it is really easier to understand the distribution of data directly from the layout. The first thing to do is find the primary parent node (in this case "A1") and insert it in cell H56. after I go to search, in the input sheet ,for the first value I encounter that has the value "A1" as parent and I place it in the Connection logic sheet next to the previous value (in this case cell I56) and repeat for all data. Obviously a parent value can have several child values ​​connected (eg. B6 -> X_46, X_54 ..). In this case the first value is inserted alongside and the following ones above with an offset of one cell.

the values ​​do not respect a hierarchical order; example X_23 is not necessarily generated by a smaller number (X_22) or vice versa and I don't know its order

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[jimraynor]

Thanks you're cool! I am testing the code and it is great. Thanks it was really hard (for me)