Hi,

I have 5 columns with 5000 rows.
Column Headings a
C1, C2, Account, Amount, Type

I need to write a macro which will sort data by Column to:
Account, Type, Amount, C1, C2

Many Thank

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=56506