macro to sort in ascending/descending order

Hello,

I need help with a macro to sort the following in ascending/ descending order. Example, from 1-10 (up) and from 11-20 (down). Your help will be greatly appreciated. This is the macro I'm currently using:

Please Login or Register  to view this content.

...........................................................................
my preference is would be to get A317A940 and A317A201 to switch positions
A316G905
A317A201
A317A940
......................................................................
A316A200
D343A265
D316A770
D304A517
C248A510
C221A390
B265A141
B241A481
B202A112
A317A940
A317A201
A316G905
A316D902
A316C902
A316B903
A316B902
A319c520
A316A927
A316A926
A316A925
A316A922
A316A921
A316A920
A316A919
A316A918
A316A916
A316A908
A316A907
A316A904
A316A903
A316A901
A316A900

Thanks

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.