Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a macro to run sort automatically
Need a macro to run sort automatically
I need a macro to select the data till the last line and sort the data. Attaching a sample file. Hope someone help me Thanks in advance GT Attachment filename: sort.xls Download attachment: http://www.excelforum.com/attachment.php?postid=400634 --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a macro to run sort automatically
I don't open attachments but here is sample code for one method -
Sub SortNewList() Range("A5").Select 'select a cell within the list. Selection.CurrentRegion.Select 'selects everything adjoining that cell. Selection.Sort Key1:=Range("F5"), Order1:=xlAscending, Key2:=Range("D5") _ , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom 'Change criteria to fit your list needs. Range("A1").Select 'Begining of sheet. End Sub "gmangad " wrote in message ... Need a macro to run sort automatically I need a macro to select the data till the last line and sort the data. Attaching a sample file. Hope someone help me Thanks in advance GT Attachment filename: sort.xls Download attachment: http://www.excelforum.com/attachment.php?postid=400634 --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort automatically | Excel Worksheet Functions | |||
Macro to Sort automatically when file/save is selected | Excel Discussion (Misc queries) | |||
Automatically Sort Tables | Excel Discussion (Misc queries) | |||
sort automatically | Excel Worksheet Functions | |||
Macro to Sort Automatically Based on Contents of Drop-down Box | Excel Programming |