Hi all,
am looking for some solution to derive multiple parent-child relationships up to nth level based on raw data.
i.e. multiple parent multiple children and even cross combinations. -- taking parent as the primary key or known starting points
I have taken explored over this forum and found few codes that do matches with my requirement but it only depicts linear relationship and not cross relationship (loopback relationship).
reference thread http://www.ozgrid.com/forum/showthread.php?t=158667
Also, I am facing some issues in executing the code taken from above thread as below -
Sub DisplayTree(ByVal sParent As String, dic As Dictionary, rOut As Range, _
ByRef lRow As Long, ByVal lLevel As Long)
Error "User-defined type not defined"
forum.ozgrid.com/index.php?attachment/72649/
[ATTACH=CONFIG]72650[/ATTACH]
Am using Excel 2013 -- So some help here would be appreciated.
Dataset & code excel file is as attached. I am using exactly the same data first to check out the output as explained in reference thread.
Then modify it for Loopback relationship scenario.