re-order excel file columns (1 Viewer)

[jeo]

i'm just wondering if anyone knows of a way to re-format an excel file.
i have a file with a bunch of data on it with different columns. then i have a certain layout that this excel file must be in before i can use it.
let's say i have original file as follows:
column a - age
column b - name
column c - address
column d - ss#

and i need it to be in the following format:
column a - ss#
column b - names
column c - age
column d - address

i have a lot of clumns, not just 4 and it would take a lot of manual work to get them in the proper order. is there a way to do this somehow programatically?
thanks.

 

[ajetrumpet]

i'm just wondering if anyone knows of a way to re-format an excel file.
i have a file with a bunch of data on it with different columns. then i have a certain layout that this excel file must be in before i can use it.
let's say i have original file as follows:
column a - age
column b - name
column c - address
column d - ss#

and i need it to be in the following format:
column a - ss#
column b - names
column c - age
column d - address

i have a lot of clumns, not just 4 and it would take a lot of manual work to get them in the proper order. is there a way to do this somehow programatically?
thanks.

I found this on another site. It might be just the thing for you...

 

[DanG]

A more manual but effective way...
http://www.exceltip.com/st/Sorting_by_Columns/248.html
I inserted a row above the current column headers and numbered the cells in the order I wanted and poof!

 

[jeo]

Thanks! I will try both of these as I need something to get this process complete a little faster.