Hello, rather than using on sheet formulas and dropdowns why not use a
userform with listboxes and comboboxes?

You can view some of my demo stuff at
http://www.geocities.com/excelmarksway

you can send me the data at:
excelmarksway@yahoo.com.au

it takes about a few days to set up..

- -Mark



"cjtj4700" wrote:

> Hi Excel Gurus,
> I am very green @ XL so bear with me. I have created a shipping request
> form and added data validation drop down lists for every category (ship to
> company name, address, city, etc.) This data was imported from our preferred
> carriers online address book. What I am looking for is a way to have the
> source list update each time a user enters a new entry and have it placed
> into the appropriate list alphabetically. These are routinely shipped to
> locations but there are over 100 and growing each day.
> Thus far XL appears to be able to do anything except make me a cup of
> coffee so I just know what I am asking help for is probably "XL 101" to you
> all! Please bear in mind that simply replying with a code will do a fly by on
> me!!
> Thx in advance. CJ