 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Another sorting question - easy one!
Finally figured out how to sort my information but this is my next question. Everything is sorted alphabetically by the first column (Name)...when I enter a new name now, will it automatically sort? Or - do I have to do this exercise of sorting on a constant basis. Thanks! my experience say you have to sort manually every time unless you I import it into Access and generate queries or reports. you included details about ...alphabetically by the first column... is that what you want? you can queue it to sort by which ever column(s) you want. > Finally figured out how to sort my information but this is my next > question. Everything is sorted alphabetically by the first column > (Name)...when I enter a new name now, will it automatically sort? Or - do > I have to do this exercise of sorting on a constant basis. > Thanks! Yes I always want it by the first column > my experience say you have to sort manually every time unless you I import > it into Access and generate queries or reports. [quoted text clipped - 8 lines] >> I have to do this exercise of sorting on a constant basis. >> Thanks! You could use a worksheet_change event to fire an automatic macro upon any entry. Is this ONE cell in col A or any cell within a range of, say a2:a200???  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Finally figured out how to sort my information but this is my next > question. Everything is sorted alphabetically by the first column > (Name)...when I enter a new name now, will it automatically sort? Or - do > I have to do this exercise of sorting on a constant basis. > Thanks! The ONE cell in Col A ranges from a2 to infinity... > You could use a worksheet_change event to fire an automatic macro upon any > entry. Is this ONE cell in col A or any cell within a range of, say [quoted text clipped - 5 lines] >> I have to do this exercise of sorting on a constant basis. >> Thanks! Private Sub Worksheet_Change(ByVal Target As Range) lastrow=cells(rows.count,"a").end(xlup).row Set myrng = Range("a2:f" & lastrow) If Not Intersect(Target, myrng) Is Nothing Then myrng.Sort Key1:=Range("a2"), Order1:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End If End Sub SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > The ONE cell in Col A ranges from a2 to infinity... > [quoted text clipped - 7 lines] >>> do I have to do this exercise of sorting on a constant basis. >>> Thanks!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.