If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting a list
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 |
#2
|
|||
|
|||
Sorting a list
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 |
#3
|
|||
|
|||
Sorting a list
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting an Address List | steve_g | Worksheet Functions | 4 | June 17th, 2005 06:36 PM |
Sorting Contacts List | Keeley | Contacts | 1 | November 15th, 2004 09:31 PM |
Sorting 3 columns as a whole (not independently ) - Help on Karaoke Song List sheet | magicianstalk | Worksheet Functions | 2 | April 2nd, 2004 06:34 PM |
Sorting using an imported list | Jay Fincannon | Worksheet Functions | 0 | December 9th, 2003 12:48 AM |
list sorting | jake | Worksheet Functions | 1 | October 2nd, 2003 06:39 PM |