How does one ADD to a dropdown list?
 

I created a dropdown list. I tried to add another item to the list, but the
list does not seem to want to include it. I've blocked the list, go into the
name field, use the same name, but it defaults to my original list and does
not include my additional rows/items.

How does one ADD to a dropdown list?
 

Did you create the drop-down using Data Validation? If so, select the
cell and click on Data | Validation | Settings tab. Under Allow: you
should have List, and then check that the Source box references your
amended data.

Hope this helps.

Pete

On Sep 22, 12:45*am, Paralegal
wrote:
I created a dropdown list. I tried to add another item to the list, but the
list does not seem to want to include it. I've blocked the list, go into the
name field, use the same name, but it defaults to my original list and does
not include my additional rows/items.

How does one ADD to a dropdown list?
 

If you want to add items dynamically to the drop down; try
DataValidationAllow List and then

If your current source is as below (starts from row2)
=$A$2:$A$4

change that to
=OFFSET(A2,0,0,COUNTA(A:A)-1)


If your list data starts from the 1st row like
=$A$1:$A$4

then change that to below
=OFFSET($A$1,0,0,COUNTA(A:A))

Now try adding items to your list data and those will be reflected in the
drop down

If this post helps click Yes
---------------
Jacob Skaria


"Pete_UK" wrote:

Did you create the drop-down using Data Validation? If so, select the
cell and click on Data | Validation | Settings tab. Under Allow: you
should have List, and then check that the Source box references your
amended data.

Hope this helps.

Pete

On Sep 22, 12:45 am, Paralegal
wrote:
I created a dropdown list. I tried to add another item to the list, but the
list does not seem to want to include it. I've blocked the list, go into the
name field, use the same name, but it defaults to my original list and does
not include my additional rows/items.

How does one ADD to a dropdown list?
 

I name an array, and then make a call to it in the standard validation
dialogs for the list selection.

Then, whenever one wants to add data to the drop down list, all one
needs do is insert a row *from within* the named array boundaries, and it
will auto-expand the named range, and hence, the drop down list.


On Mon, 21 Sep 2009 18:51:01 -0700, Jacob Skaria
wrote:

If you want to add items dynamically to the drop down; try
DataValidationAllow List and then

snipped also 100% valid solution. :-]