automatically change the order of fields in a sheet
 

Does anyone know how to automatically change the order of fields in
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 Actio

--
minrufen
-----------------------------------------------------------------------
minrufeng's Profile: http://www.excelforum.com/member.php...fo&userid=2620
View this thread: http://www.excelforum.com/showthread.php?threadid=39568

automatically change the order of fields in a sheet
 

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" wrote in
message ...

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