The file homework8.xlsx contains a list of flight information in columns A, B, and C.
The list includes origin, destination, and flight #s of each flight.
You are interested in flights that leave from any city in column E and end up at any city in column F. You need to list such flights in columns H, I, and J with their respective data. (see below for example)
Write a VBA program using 1 dimensional arrays to do this.
Your code should work even if the lists change.
Solved by G. J. in 14 mins