Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrange columns
Hi all
I currently have a spreadsheet with several hundred rows and nine columns, two of the columns are numnerical values and what I am looking to achieve is to have a drop down box on my sheet which will allow me to sort the data by the two numerical columns (highest value will be the first entry). When I simply click on the header of each column it does re-arrange the data however it does not rearrange the entire row, simply the column, If the above isn't clear then please do not hesitate to contact me. TIA Craig |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrange columns
On 13 Jun, 15:42, wrote:
Hi all I currently have a spreadsheet with several hundred rows and nine columns, two of the columns are numnerical values and what I am looking to achieve is to have a drop down box on my sheet which will allow me to sort the data by the two numerical columns (highest value will be the first entry). When I simply click on the header of each column it does re-arrange the data however it does not rearrange the entire row, simply the column, If the above isn't clear then please do not hesitate to contact me. TIA Craig Try this: Selection.Sort Key1:=Range("B1"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
arrange columns through sheet and multi sheets | Excel Worksheet Functions | |||
Arrange columns (lo - hi) in a Pivot Chart bar graph. | Charts and Charting in Excel | |||
How do I arrange columns alphabetically by column label? | Excel Worksheet Functions | |||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
arrange columns alphabetically in Excel | New Users to Excel |