I have a problem of district heating piping. My purpose is to define an algorithm to size the branched type piping according to the load (pipe has on it).

As you can estimate: the predecessor piping has the load of the successor piping/s. But the next problem is that the successor piping/s of the first predecessor piping has/have following pipings also..

So the nodes (start and end point of the piping) have to be linked together with Linked List Theory (according to my search in Google)..

But how? Would you please help me to find codes and/or explanation of the Linked List Theory for Macro of Excel?

Thank you.