Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting out columns but only for some rows
Hi,
I would like to create a macros that will sort out the first 5 rows of my spreadsheet only. The reason for that is that in the middle of my spreadsheet i have another group of cells that represent a table and I don't want that one to be sorted. How can i do that ? Thx |
#2
|
|||
|
|||
Sam,
Either select just the cells that you want sorted, prior to the sort, or insert a new row between the tables to prevent them being sorted together. HTH, Bernie MS Excel MVP "Sam" wrote in message oups.com... Hi, I would like to create a macros that will sort out the first 5 rows of my spreadsheet only. The reason for that is that in the middle of my spreadsheet i have another group of cells that represent a table and I don't want that one to be sorted. How can i do that ? Thx |
#3
|
|||
|
|||
Hi Sam
something along these lines sub sortsome() Rows("1:5").Sort Key1:=Range("a2"), Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End sub where you have a header row (if not, change Header:=xlYes to Header:=xlNo and A2 to A1) and you want to sort on the value in column A, if not, change the A to whatever column you want to sort on -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Sam" wrote in message oups.com... Hi, I would like to create a macros that will sort out the first 5 rows of my spreadsheet only. The reason for that is that in the middle of my spreadsheet i have another group of cells that represent a table and I don't want that one to be sorted. How can i do that ? Thx |
#4
|
|||
|
|||
oops the _ was supposed to be on the same lines as the xlYes,
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "JulieD" wrote in message ... Hi Sam something along these lines sub sortsome() Rows("1:5").Sort Key1:=Range("a2"), Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End sub where you have a header row (if not, change Header:=xlYes to Header:=xlNo and A2 to A1) and you want to sort on the value in column A, if not, change the A to whatever column you want to sort on -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "Sam" wrote in message oups.com... Hi, I would like to create a macros that will sort out the first 5 rows of my spreadsheet only. The reason for that is that in the middle of my spreadsheet i have another group of cells that represent a table and I don't want that one to be sorted. How can i do that ? Thx |
#5
|
|||
|
|||
i've done that. but it still modifies the rows below.
You can find my spreadsheet he http://graphicsxp.no-ip.com/share/Book1.xls maybe I haven't been clear enough about what i want to achieve and you'll get the visual straight away. Thx |
#6
|
|||
|
|||
The recorded macro below seems to be able to do the job ..
(Sort by col C - Descending, then by col B - ascending) Sub Macro2() Sheets("Sheet1").Select Rows("1:6").Select Selection.sort Key1:=Range("C2"), Order1:=xlDescending, Key2:=Range("B2") _ , Order2:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False _ , Orientation:=xlTopToBottom Range("A1").Select End Sub -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Sam" wrote in message oups.com... i've done that. but it still modifies the rows below. You can find my spreadsheet he http://graphicsxp.no-ip.com/share/Book1.xls maybe I haven't been clear enough about what i want to achieve and you'll get the visual straight away. Thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
Sorting rows AND columns | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) |