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

Select the entire sheet by clicking the grey box above row 1 and to the
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 corresponding
column with the Group #.

Select OK.

Does this help?


--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718
View this thread: http://www.excelforum.com/showthread...hreadid=496426

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 |
+-------------------------------------------------------------------+

--
VBAvirgin
------------------------------------------------------------------------
VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327
View this thread: http://www.excelforum.com/showthread...hreadid=496426