VBA Arrays

[cgarcia8807]

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?

[bakerman2]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[cgarcia8807]

Thanks. I've uploaded the spreadsheet.

[bakerman2]

Apparently this is a homework assignment as per your example file title.

Therefore forum policy prohibits us from giving you direct answers. We can however put you on the right path to a solution.

First of all you will need 3 arrays. 1 that holds your flight data (columns A, B & C), 1 that holds your origin data (column E) and the last one destination data (column F).

Are you familiar with filling arrays ?