Im no expert but the way i would-

1)record macro
2)select all data
3)copy and paste into appropriate place
4)select it and under data sort ascending.


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=486874