Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting 100 rows of 6 records horizontally
I would like to sort the 6 records in each separate row (100 total) ascending.
Is there a built-in function to do that. I tried to use the macro recorder to sort the rows manually but 100 is too tedious, I would appreciate any hints for a killer macro.. TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting 100 rows of 6 records horizontally
perhaps you could transpose the 6cols x 100 rows to 100 cols x 6 rows, use
the columns.sort method (or some such) to sort each column alone, then retranspose to 6 x 100. -- Bob Kilmer "Victor" wrote in message ... I would like to sort the 6 records in each separate row (100 total) ascending. Is there a built-in function to do that. I tried to use the macro recorder to sort the rows manually but 100 is too tedious, I would appreciate any hints for a killer macro.. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting 100 rows of 6 records horizontally
I had already tried that but it only sorts the first 3
columns at the max -----Original Message----- perhaps you could transpose the 6cols x 100 rows to 100 cols x 6 rows, use the columns.sort method (or some such) to sort each column alone, then retranspose to 6 x 100. -- Bob Kilmer "Victor" wrote in message ... I would like to sort the 6 records in each separate row (100 total) ascending. Is there a built-in function to do that. I tried to use the macro recorder to sort the rows manually but 100 is too tedious, I would appreciate any hints for a killer macro.. TIA . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting 100 rows of 6 records horizontally
Go programmatically thru the columns, sorting each column itself, not the
entire range of columns. -- Bob Kilmer "Victor" wrote in message ... I had already tried that but it only sorts the first 3 columns at the max -----Original Message----- perhaps you could transpose the 6cols x 100 rows to 100 cols x 6 rows, use the columns.sort method (or some such) to sort each column alone, then retranspose to 6 x 100. -- Bob Kilmer "Victor" wrote in message ... I would like to sort the 6 records in each separate row (100 total) ascending. Is there a built-in function to do that. I tried to use the macro recorder to sort the rows manually but 100 is too tedious, I would appreciate any hints for a killer macro.. TIA . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting 100 rows of 6 records horizontally
Option Explicit
Sub SortColumns() Dim rng As Range Dim col As Range Set rng = Workbooks("Book2.xls").Worksheets("Sheet1").Column s For Each col In rng rng.Sort col Next End Sub Change rng to whatever range you like. Perhaps, for your case, Set rng = Workbooks("Book2.xls").Worksheets("Sheet1").Column s("A:CV") '100 columns There are also clever ways to select the range dynamically, or you can use the active selection (called Selection). -- Bob Kilmer "Victor" wrote in message ... I had already tried that but it only sorts the first 3 columns at the max -----Original Message----- perhaps you could transpose the 6cols x 100 rows to 100 cols x 6 rows, use the columns.sort method (or some such) to sort each column alone, then retranspose to 6 x 100. -- Bob Kilmer "Victor" wrote in message ... I would like to sort the 6 records in each separate row (100 total) ascending. Is there a built-in function to do that. I tried to use the macro recorder to sort the rows manually but 100 is too tedious, I would appreciate any hints for a killer macro.. TIA . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help for Medical Records sorting | Excel Worksheet Functions | |||
Selecting vertical rows and displaying them horizontally. | Excel Discussion (Misc queries) | |||
Sorting Individual Rows Horizontally | Excel Discussion (Misc queries) | |||
How to turn rows horizontally to form columns? | Excel Worksheet Functions | |||
Sorting Records | Excel Discussion (Misc queries) |