 |
 | 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 / Setup / November 2006Sorting data
Is there a way to automaticaly sort data. For E.G. I have a list of venders with their names in column B, Telephone No. in column C, Addresse in column D and so on. And then when I need to insert a new vender I want to use a macro to insert a new line in the top of the list, put in all the information, and then I want that it should sort all the venders again so it should be everything in order. Is there a way it should get automaticaly done or in the macro? I tried doing it in the macro but it only sorted part of the data, not the whole list?! Please help! How about just adding them to the bottom of the data and when you're done, you could sort the range. In xl2003, you can apply data|filter|autofilter to the range and use the dropdown arrow to sort your data. Debra Dalgleish has a technique at her site that adds invisible rectangles in the headers and then sorts the data by that field when you click on one of those rectangles. http://contextures.com/xlSort02.html > Is there a way to automaticaly sort data. For E.G. I have a list of venders > with their names in column B, Telephone No. in column C, Addresse in column D [quoted text clipped - 4 lines] > macro? I tried doing it in the macro but it only sorted part of the data, not > the whole list?! Please help!  SignatureDave Peterson I cannot add it in the bottem of the list, because I made a combo dropdown list from all the venders and if I'll add by the bottom of the list, then it won't be part of the combo dropdown list. I want all venders always to be in the drop down list. How can I do that? > How about just adding them to the bottom of the data and when you're done, you > could sort the range. [quoted text clipped - 16 lines] > > macro? I tried doing it in the macro but it only sorted part of the data, not > > the whole list?! Please help! Use a Dynamic Range for the list. See Debra Dalgleish's site for defing a dynamic range name. http://www.contextures.on.ca/xlNames01.html#Dynamic Also useful may be her info on Combo Boxes. http://www.contextures.on.ca/xlDataVal11.html Gord Dibben MS Excel MVP >I cannot add it in the bottem of the list, because I made a combo dropdown >list from all the venders and if I'll add by the bottom of the list, then it [quoted text clipped - 21 lines] >> > macro? I tried doing it in the macro but it only sorted part of the data, not >> > the whole list?! Please help!
|
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.