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 he

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

Or, to redefine the existing range:
Choose InsertNameDefine
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.