automatically change the order of fields in a sheet

Does anyone know how to automatically change the order of fields in a sheet

rather than using cut-paste.

Please see attachment. Thank you for your great help!

Original Field Order:
Date Acct Amount Unit Purpose Detail Obj Sub Obj Rev Sub

Rev Doc # Description Vendor Action Period

New Field Order:
Acct Period Obj Sub Obj Rev Sub Rev Date Amount Unit

Purpose Detail Doc # Description Vendor Action

Were these fields imported from a database? If so, the order can be
controlled at the time of import. How was the data obtained?

Mike F
"minrufeng" <[email protected]> wrote in
message news:[email protected]...
>
> Does anyone know how to automatically change the order of fields in a
> sheet
>
> rather than using cut-paste.
>
> Please see attachment. Thank you for your great help!
>
> Original Field Order:
> Date Acct Amount Unit Purpose Detail Obj Sub Obj Rev Sub
>
> Rev Doc # Description Vendor Action Period
>
> New Field Order:
> Acct Period Obj Sub Obj Rev Sub Rev Date Amount Unit
>
> Purpose Detail Doc # Description Vendor Action
>
>
> --
> minrufeng
> ------------------------------------------------------------------------
> minrufeng's Profile:
> http://www.excelforum.com/member.php...o&userid=26208
> View this thread: http://www.excelforum.com/showthread...hreadid=395687
>