Update Excel Data List for Drop Down use

I have created data lists that were named (name field left of formula field)
and have those lists tied to cells as drop down data validation options. I
now need to add additional entries to the data lists, but am unable to get
them added into the existing groups. I've tried re-highlighting and naming
again - no go.
I am an admitted novice, but really look forward to getting this recurring
document as drop and click as possible. Appreciate any help.

You could use a dynamic range, that would automatically expand to
include new entries. There are instructions here:

http://www.contextures.com/xlNames01.html

Or, to redefine the existing range:
Choose Insert>Name>Define
Select the name in the list
In the Refers to, change the cell reference
Click OK

LynnS wrote:
> I have created data lists that were named (name field left of formula field)
> and have those lists tied to cells as drop down data validation options. I
> now need to add additional entries to the data lists, but am unable to get
> them added into the existing groups. I've tried re-highlighting and naming
> again - no go.
> I am an admitted novice, but really look forward to getting this recurring
> document as drop and click as possible. Appreciate any help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

This can be as easy as inserting a cell in the middle of the range that you
initially created, this will update the data that is referenced by the
validation program.

"LynnS" wrote:

> I have created data lists that were named (name field left of formula field)
> and have those lists tied to cells as drop down data validation options. I
> now need to add additional entries to the data lists, but am unable to get
> them added into the existing groups. I've tried re-highlighting and naming
> again - no go.
> I am an admitted novice, but really look forward to getting this recurring
> document as drop and click as possible. Appreciate any help.