If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting 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! |
#2
|
|||
|
|||
Sorting data
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 art wrote: 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! -- Dave Peterson |
#3
|
|||
|
|||
Sorting data
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? "Dave Peterson" wrote: 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 art wrote: 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! -- Dave Peterson |
#4
|
|||
|
|||
Sorting data
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 On Tue, 28 Nov 2006 10:54:32 -0800, art wrote: 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? "Dave Peterson" wrote: 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 art wrote: 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! -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|