Recurse a list of parent/children and calculate the longest cumulative length for the initial parent.
Input is the initial parent, and the data is in three fields - parent, child and length.
## Deliverables
For a Parent (root parent) on Sheets("PARENTS"), I need to recurse Sheets("LENGTHS") and get the longest cumulative length from root parent to ending branch.
For example, root parent 2501 has 5 possible paths. Cumulative lengths and last child are listed below.
Child - Cumulative Distance
190201 - 375
2006600 - 775
2007404 - 775
43229 - 655
43249 - 924
The program would identify 924 as the Max Cumulative Length and return it to Sheets("PARENTS") in cell B2.
Thanks!