VB Inserting different end points for flight tracks varying points each time. Unbelievably stuck now!

[Johnno1980]

Hi All,

I have tried various ways and still finding problems so I hope you are able to assist. I currently have a new macro which pulls a text file. In turn adds various points to a leading track. The end points may have 1/2/3/4 different end points and inn turn the leading tracks may also vary in number. So each leading track will need to be multiplied for the amount of end points with their respective point added to the end . I hope the below view shows the original and output I am looking to achieve but unfortunately I am unable to come up with a solution and your great assistance will be hugely appreciated. Many thanks i advance all. Steve

Type	Original Data	End Waypoints Differ	Output data should look like this
End Point 1	DC METRO DEPARTURES OVER TOPPS/EBONY PLEASE FILE: <tbody> </tbody>	New End Point
Leading track	SWANN.BROSS.J42.RBV.LLUND.BAYYS.PUT.	TOPPS	SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT TOPPS
Leading track	SWANN.BROSS.J42.RBV.LLUND.BAYYS.PUT.	EBONY	SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT EBONY
End Point 2	DC METRO DEPARTURES OVER ALLEX PLEASE FILE: <tbody> </tbody>	New End Point
Leading track	SWANN.BROSS.J42.RBV.LLUND.BAYYS.PUT.WITCH.	ALLEX	SWANN..BROSS.J42.RBV..LLUND..BAYYS..PUT..WITCH ALLEX
End Point 3	DC METRO DEPARTURES OVER BRADD/KANNI PLEASE FILE: <tbody> </tbody>	New End Point
Leading track	AGARD.SIE.J121.SHLEP.ACK.	BRADD	AGARD..SIE.J121.SHLEP..ACK BRADD
Leading track	AGARD.SIE.J121.SHLEP.ACK.	KANNI	AGARD..SIE.J121.SHLEP..ACK KANNI
Leading track	OR SWANN.BROSS.J42.RBV.ACK.	BRADD	OR SWANN..BROSS.J42.RBV..ACK BRADD
Leading track	OR SWANN.BROSS.J42.RBV.ACK.	KANNI	OR SWANN..BROSS.J42.RBV..ACK KANNI
End Point 4	DC METRO DEPARTURES OVER WHALE PLEASE FILE: <tbody> </tbody>	New End Point
Leading track	AGARD.SIE.J121.SHLEP.YAHOO.	WHALE	AGARD..SIE.J121.SHLEP..YAHOO WHALE
Leading track	OR SWANN.BROSS.J42.RBV.YAHOO.	WHALE	OR SWANN..BROSS.J42.RBV..YAHOO WHALE
End Point 5	DC METRO DEPARTURES OVER DOVEY PLEASE FILE: <tbody> </tbody>	New End Point
Leading track	AGARD.SIE.B24.LYNUS.LARGE.	DOVEY	AGARD..SIE.B24.LYNUS..LARGE DOVEY

<tbody>
</tbody>

Each end point will have "OVER" followed by one end point or multiple devided with "/" this could be two/three/four different end points

With that in mind the leading track needs to be duplicated by the amount of times there are end points for the above "End Point"

The output I have on the right.

E.g End point 1 has 2 end points therefore I need to duplicate the leading track twice and add the two to the end.

E.g End point 3 has 2 end points but also has two leadinng tracks so each leading track needs to be duplicated and the end points added.

E.g End point 4 has one end point but 2 leading tracks therefore the end point "Whale" needs to be added to both.

I hope this makes sense and you can help me as I am at a loss now and it's the last piece in a huge puzzle.

<tbody>
</tbody>