drop down list

Giganews Newsgroups
Subject: drop down list
Posted by:  nip (gbrea…@gmail.com)
Date: Thu, 3 Jul 2008

Is there a way to create a drop down list in a cell which can be added
to?  Excel 2007
Currently have a worksheet with a list in cells z50>z55 with entries
Then selected g5 to 50 and data validate > list > named range z50>55
Works well except when there is a change to one of the figures in the
list
Other than picking from this list no other entry can be made in g 5 >
50
So would like to be able to add other numbers to the list and have it
grow
Is this possible?

Replies