Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto-arrange
Hello all, I am quite new to spreadsheets and was wondering if anybody could help me with this problem. I have attached an image of what I'm working on. Ideally, when I enter new data, the rows should automatically arrange themselves oldest to newest by the date in column G. As far as I know, this has to be done with code? Could someone point me in the right direction as I have no experience with this.
Thanks again. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-arrange
Right click sheet tabview codeinsert this. Now when you add a date
at the BOTTOM of col G, Col G will sort. If you want the other way, change xlAscending to xlDEScending Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Or Target.Column < 7 Then Exit Sub Range("g1:G" & Target.Row).Sort _ Key1:=Range("G1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, Orientation:=xlTopToBottom End Sub On Feb 3, 4:54*pm, Mattaphylactic <Mattaphylactic. wrote: Hello all, I am quite new to spreadsheets and was wondering if anybody could help me with this problem. I have attached an image of what I'm working on. Ideally, when I enter new data, the rows should automatically arrange themselves oldest to newest by the date in column G. As far as I know, this has to be done with code? Could someone point me in the right direction as I have no experience with this. Thanks again. +-------------------------------------------------------------------+ |Filename: excelhelp3.jpg * * * * * * * * * * * * * * * * * * * * * | |Download:http://www.excelbanter.com/attachment.php?attachmentid=288| +-------------------------------------------------------------------+ -- Mattaphylactic |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-arrange
Hi,
a way to learn is to record all your actions as you do into a macro. One done you can filterout/delete all garbage lines and testing if all still applies. choose range / and apply sort "Mattaphylactic" schreef in bericht ... Hello all, I am quite new to spreadsheets and was wondering if anybody could help me with this problem. I have attached an image of what I'm working on. Ideally, when I enter new data, the rows should automatically arrange themselves oldest to newest by the date in column G. As far as I know, this has to be done with code? Could someone point me in the right direction as I have no experience with this. Thanks again. +-------------------------------------------------------------------+ |Filename: excelhelp3.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=288| +-------------------------------------------------------------------+ -- Mattaphylactic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Arrange | Excel Worksheet Functions | |||
Auto Arrange Chart Labels | Charts and Charting in Excel | |||
how to auto arrange in alphabetical order-excel sheet | New Users to Excel | |||
How to auto arrange the worksheet in a excel 2002 file? | Excel Worksheet Functions | |||
How do I set up a click "column title" and auto arrange data form. | Excel Discussion (Misc queries) |