I will try to keep this a simple as possible. I have a sheet with a list of flights, the origin of the flight in column A and the destination of the flight in column B. I want to be able to type in an origin and destination in lets say cells F1 and G1, and have a macro determine all possible routings since there is most likely no direct connection.
For example using the table below, if I typed in PDX to BRU, I would want to show three routing combinations;
<tbody>
</tbody>
For example using the table below, if I typed in PDX to BRU, I would want to show three routing combinations;
- PDX-CVG-BRU
- PDX-CVG-LEJ-BRU
- PDX-SEA-CVG-BRU
- PDX-SEA-CVG-LEJ-BRU
Origin | Destination |
PDX | SEA |
SEA | CVG |
CVG | LEJ |
CVG | BRU |
LEJ | BRU |
PDX | CVG |
<tbody>
</tbody>