Sorting a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Clueless27 - 28 Dec 2005 16:30 GMT

I need to sort a list by group #. The list consists of 8 colums of info
accross, and so i need to sort left- to right. Not sure how to go about doing
this correctly without losing info!

thanks,

megan

Reply to this Message

surg4u1975 - 28 Dec 2005 16:41 GMT

Select the entire sheet by clicking the grey box above row 1 and to th
left of column A.

Go to 'Data' on the top menu bar.

Select Sort.

Check the box for Header row if your data has headers.

Then select, using the drop down arrow, Group # or the correspondin
column with the Group #.

Select OK.

Does this help

Reply to this Message

VBAvirgin - 30 Dec 2005 17:18 GMT

See Code:

Code:
--------------------
Private Sub CommandButton1_Click()
Application.Run "SortTest1!SelectNSort"
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("A1").Select
End Sub

--------------------

Try the attached file (Click the button)
Edit the code by way of the VBA editor, and where I have
"Selection.Sort Key1:=Range("A1")," Change *A1* to *B1*, and click the
button again to see the results.
This should give you an idea as to what's happening in the SORT".

Good Luck in your endeavours.

+-------------------------------------------------------------------+

|Filename: SortTest1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4164 |

+-------------------------------------------------------------------+

Signature

VBAvirgin

Reply to this Message