Excell should have more data sorting features
 

how do u sort data by multiple rows? for example i have number values of 2
rows and 10 columns.
eg: 25 15 01 69 56 55 23 45 03 14 ...
58 68 33 45 02 07 78 90 53 44 ...
so on with multiple columns and multiple rows.

although there is a feature that allowes us to sort each row individualy, i
would like to know if there is a feature that allowes us to sort large
amounts of rows in one go. So that the above example - two rows should look
like this.

01 03 14 15 23 25 45 55 56 69
02 07 33 44 45 53 58 68 78 90

notice how they are sorted by single row. but without sorting each and every
row individually there needs to be a feature for multiple rows.



please email me back if theres already a feature like this at your earliest.
thanks



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Excell should have more data sorting features
 

One of the reasons to learn about macros is to do repetitive tasks.

If you want to try....

This assumes that your data starts in column A and row 1 is a header row.

Option Explicit
Sub testme01()

Dim myRng As Range
Dim iRow As Long
Dim FirstRow As Long
Dim LastRow As Long
Dim wks As Worksheet

Set wks = Worksheets("sheet1")

With wks
FirstRow = 2 'headers in row 1??
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row

For iRow = FirstRow To LastRow
Set myRng = .Range(.Cells(iRow, "a"), _
.Cells(iRow, .Columns.Count).End(xlToLeft))
myRng.Sort key1:=myRng.Cells(1), order1:=xlAscending, _
Header:=xlNo, Orientation:=xlLeftToRight
Next iRow
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sanjeev wrote:

how do u sort data by multiple rows? for example i have number values of 2
rows and 10 columns.
eg: 25 15 01 69 56 55 23 45 03 14 ...
58 68 33 45 02 07 78 90 53 44 ...
so on with multiple columns and multiple rows.

although there is a feature that allowes us to sort each row individualy, i
would like to know if there is a feature that allowes us to sort large
amounts of rows in one go. So that the above example - two rows should look
like this.

01 03 14 15 23 25 45 55 56 69
02 07 33 44 45 53 58 68 78 90

notice how they are sorted by single row. but without sorting each and every
row individually there needs to be a feature for multiple rows.


please email me back if theres already a feature like this at your earliest.
thanks



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson