VBA Arrays

I am working on writing code in VBA to perform the procedure listed below.


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 2nd page for example)

Write a VBA program using 1 dimensional arrays to do this.

Your code should work even if the lists change.


I've identified by array but can't figure out how to write code to copy flights that match the criteria and paste in the output columns. Can anyone help?