a. Remove the DV for that particular cell (most obvious way?), or,
b. Try using dynamic ranges for the DVs to auto-expand the list in the
dropdown for any new items. See Debra's notes at:
http://www.contextures.com/xlNames01.html#Dynamic

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"BinaH57" wrote:
However having done that it seems that I am only bound by the data in the
list. Is there a way I can also enter/type data that is NOT in the defined
list? i.e a new customer whose details are not already entered.