On Mon, 8 Feb 2010 15:05:01 -0800, Sue
wrote:

I have a question regarding the drop downs lists created using Data
Validation. Is there any way to make them so that when I type something new
into the box that it is automatically added to the drop down list? Thank you!!


Yes. I use a range of cells that are referred to by the validator.

Check this out. You name a range of cells (a single column group) and
use that named range in the drop down list criteria box as =rangename

Example name the range "List1" and use "=List1" in the drop down box.

Now, as you INSERT rows within that original named range, the range
auto-expands.

There are also auto-expanding formulas you can use.

Check out my workbook:

http://office.microsoft.com/en-us/te...CT101172771033