Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
data sorting | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |