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?

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?

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?