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