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?