View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?