| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving data in pull down lists?
Is it possible for Excel to save the old number of a cell into a pull down
list when another number is put into the cell? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving data in pull down lists?
Maybe this from Debra Dalgleish's site
http://www.contextures.on.ca/excelfiles.html#DataVal DV0038 - Flexible Item List -- Use formulas to automatically add new unique items to a data validation dropdown list. Sample file from Ron Coderre. DataValFlexList.zip 7kb 18-Feb-06 Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 13:37:16 -0700, NervousFred wrote: Is it possible for Excel to save the old number of a cell into a pull down list when another number is put into the cell? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving data in pull down lists?
Gord,
This works good, but now I have another issue.(The issues never stop) If I input a value into the table I am importing into excel and then refresh the table the value I just put in is overwritten by the incoming data. Is it possible to "lock" a value into a cell that is in an imported table so that when I do refresh the table the value remains constant? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a pull down lists? | Excel Discussion (Misc queries) | |||
| Pull down lists | Excel Discussion (Misc queries) | |||
| Pull Down Lists | Excel Discussion (Misc queries) | |||
| populate fields based upon pull down lists | Excel Worksheet Functions | |||
| Pull down lists | Excel Discussion (Misc queries) | |||
Linear Mode
