Requesting for the vba programm for excel for input in sheet 1 and output in sheet 2, if i have list of data

distance between 2 nodes A, B is 6 and same more then how can i find all possible paths between all two nodes as

data

A-B=6, B-C=5, C-D=5, E-F=5, F-G=5, C-G=6, G-H=6, D-E=5

OUTPUT

DISTANCE BETWEEN

A-H = 1) A-B-C-G-H=23, 2) A-B-C-D-E-F-G-H=36

C-D = 1) C-D=5, 2) C-G-F-E-D=21

A-B = 6

B-C =5

And more others

Started by Sachin at July 30, 2018 - 8:27 AM

Requesting for the vba programm for excel for input in sheet 1 and output in sheet 2, if i have list of data

distance between 2 nodes A, B is 6 and same more then how can i find all possible paths between all two nodes as

data

A-B=6, B-C=5, C-D=5, E-F=5, F-G=5, C-G=6, G-H=6, D-E=5

OUTPUT

DISTANCE BETWEEN

A-H = 1) A-B-C-G-H=23, 2) A-B-C-D-E-F-G-H=36

C-D = 1) C-D=5, 2) C-G-F-E-D=21

A-B = 6

B-C =5

And more others

Started by Sachin at July 30, 2018 - 8:27 AM