Data validation list type

[Guest]

I have a drop down list on a spread sheet that gets it's list from a series
of cells. I would like to be able to add to or remove values from the list
without having to change the name of the list. Can someone tell me how this
is done?

 

[Ron Coderre]

Base the DV list on a Dynamic Range Name....which automatically expands and
contracts to accommodate the available data.
This link has instructions on building them:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Darren Hill]

While Ron's suggestion of Dynamic Range names is far superior, here's an
easy way when you're in a hurry:

Manually insert a cell into the list being referenced (I usually insert
the cell just before the last one).
The range name automatically expands, and you can type the new entry
into the empty cell.
Then, rearranging the list via a sort works.

Darren

-----Original Message-----
From: Ron Coderre [mailto:[email protected]]
Posted At: 19 September 2007 17:24
Posted To: microsoft.public.excel.programming
Conversation: Data validation list type
Subject: Re: Data validation list type

Base the DV list on a Dynamic Range Name....which automatically
expands and
contracts to accommodate the available data.
This link has instructions on building them:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

I have a drop down list on a spread sheet that gets it's list from a series
of cells. I would like to be able to add to or remove values from the list
without having to change the name of the list. Can someone tell me how
this
is done?