Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Excel columns in several worksheets at once.
I have information in several excel worksheets. All worksheets are formated
the same within the file. How do I sort all the worksheets at once by one of the columns, for instance sort all worksheets by column A. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Excel columns in several worksheets at once.
AFAIK, you can't. The sort option is greyed out when you group worksheets.
HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Dale60" wrote: I have information in several excel worksheets. All worksheets are formated the same within the file. How do I sort all the worksheets at once by one of the columns, for instance sort all worksheets by column A. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Excel columns in several worksheets at once.
You could record a macro that sorts the data the way you want. Then run that
same code for each worksheet that you need sorted. For example, this expects headers in row 1 of each worksheet. It sorts columns A:G and determines the last row by the last row used in column A. And it it uses column 1 (A), column 3 (C), and column 5 (E) as the key columns. Option Explicit Sub testme01() Dim myRng As Range Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets With wks Set myRng = .Range("a1:G" & .Cells(.Rows.Count, "A").End(xlUp).Row) End With With myRng .Cells.Sort key1:=.Columns(1), order1:=xlAscending, _ key2:=.Columns(3), order2:=xlAscending, _ key3:=.Columns(5), order3:=xlAscending, _ header:=xlYes End With Next wks End Sub Dale60 wrote: I have information in several excel worksheets. All worksheets are formated the same within the file. How do I sort all the worksheets at once by one of the columns, for instance sort all worksheets by column A. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Excel columns in several worksheets at once.
ps.
If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Dale60 wrote: I have information in several excel worksheets. All worksheets are formated the same within the file. How do I sort all the worksheets at once by one of the columns, for instance sort all worksheets by column A. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I add more columns in Excel past column IV | Excel Discussion (Misc queries) | |||
loosing columns in excel 2000 | Excel Discussion (Misc queries) | |||
In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) |