VB Array - Column Headers Sort

[rmfrase]

I have a spreadsheet that has at least 250 columns with headers that are in no particular order.
I need to place the column headers in a specific arrangement based on a list, and delete all remaining columns as they are not needed.

any suggestions or examples on how this can be accomplished?

 

[VoG]

Try this http://www.teachexcel.com/free-exce...excel-ascending-order-headers-with-macro.html

 

[rmfrase]

The end-result list that I have would not be in Ascending Order.

 

[rmfrase]

I'll restate my issue.

I have a spreadsheet that has at least 250 columns with headers that are in no particular order.
I need to place the column headers in a specific (but Non A-Z) arrangement based on an Array List, the Macro would look at the Array list, and move that column into a Left-Right arrangement starting at Column 1 based on the Array. Then delete all remaining columns as they are not needed.

Example column headers at start:
Red, Orange, Apple, Blue, Green, Cat, Tiger, Two, Sky, Ocean, Earth.

Array list within Macro: Blue, Red, Apple, Cat

Columns on Spreadsheet would be only: Blue, Red, Apple, Cat


all remaining headers/columns would be deleted.