Organzing CSV columns automatically for Excel

[Keres]

I have 126 columns that are out of order in a CSV file that will need to be downloaded repeatedly for data. I would like to know if there's a way to write a macro that will identify the labeled columns and place them in a pre-defined correct order with all associated data within that column?

IE: Column 1 is for FIRST_NAME, Column 2 is for LAST_NAME, and so forth. Right now, they're somewhere in column 40 & 46. I would like for all first names to be listed in Column 1 and last names in column 2 and so forth everytime I open that particular source file.

Thanks in advance,
Keres

 

[jimrward]

do you need to re-use all 126 columns or just put out select ones for your reports

 

[Keres]

Use all 126 columns, I'll be making at least 5-10 different reports.

 

[Keres]

Bumping this thread.