Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
automatic sorting in excel
I would like to be able to have a column sorted alphabetically contiuously.
In other words, whenever data is entered, the whole column gets arranged alphabetically without having to "click' on the sort function. I am not a power user of excel, but I now understand the basics of running a macro. I have been guided to use the following macro example and adapt it to my worksheet. I have tried a few changes, but I cannot get it to work. Lets say the filename is "mybook" and the worksheet name is "sheet1" and the range I want to sort automatically is B1:B20 Private Sub Worksheet_Change(ByVal Target As Range) Columns("B:B").Select Selection.Sort Key1:=Range("B1"), Order1:=xlAscending End Sub However, I am not sure exactly which part I need to change in this code, for it to work on my worksheet. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
automatic sorting in excel
See:
http://www.microsoft.com/communities...1-7676c90b18d3 -- Gary's Student "Gostal" wrote: I would like to be able to have a column sorted alphabetically contiuously. In other words, whenever data is entered, the whole column gets arranged alphabetically without having to "click' on the sort function. I am not a power user of excel, but I now understand the basics of running a macro. I have been guided to use the following macro example and adapt it to my worksheet. I have tried a few changes, but I cannot get it to work. Lets say the filename is "mybook" and the worksheet name is "sheet1" and the range I want to sort automatically is B1:B20 Private Sub Worksheet_Change(ByVal Target As Range) Columns("B:B").Select Selection.Sort Key1:=Range("B1"), Order1:=xlAscending End Sub However, I am not sure exactly which part I need to change in this code, for it to work on my worksheet. Thanks. |
#3
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
automatic sorting in excel
Try Aaron Blood's Auto Sort subroutine. Its triggered automatically by
typing, and returns the sorted version on a different sheet. Sounds exactly what you're after. See XL-Logic.com for details, you have to register to download. Gostal wrote: I would like to be able to have a column sorted alphabetically contiuously. In other words, whenever data is entered, the whole column gets arranged alphabetically without having to "click' on the sort function. I am not a power user of excel, but I now understand the basics of running a macro. I have been guided to use the following macro example and adapt it to my worksheet. I have tried a few changes, but I cannot get it to work. Lets say the filename is "mybook" and the worksheet name is "sheet1" and the range I want to sort automatically is B1:B20 Private Sub Worksheet_Change(ByVal Target As Range) Columns("B:B").Select Selection.Sort Key1:=Range("B1"), Order1:=xlAscending End Sub However, I am not sure exactly which part I need to change in this code, for it to work on my worksheet. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I remove the annoying automatic date formatting in Excel? | Excel Discussion (Misc queries) | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Excel: Allow to turn on / off automatic header selection in sorts | Excel Discussion (Misc queries) |