Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation list type
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) "hshayhorn" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation list type
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 ] Posted At: 19 September 2007 17:24 Posted To: microsoft.public.excel.programming Conversation: Data validation list type Subject: 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) "hshayhorn" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an autofill type function from a data validation box | Excel Discussion (Misc queries) | |||
Should allow data validation dependent lisand type information as | Excel Discussion (Misc queries) | |||
Data Validation type query | Excel Programming | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
Drop Down Menu (non Data Validation type) | Excel Programming |