Validation Question....Can this be done?

H

harpscardiff

I got a basic spreadsheet, with validations. There is a cloumn with the
validation list, listing all common IT problems we experience -
Hardware, PC, Mice, Keyboard, printers.

I want an option at the bottom "Add New", once clicked it will allow
you to enter a new entry in the validation list.

Any ideas how I would do this?

Cheers
Harps
 
B

Bob Phillips

Create a range with those items, say M1:Mn.

then add a dynamic range, Insert>Name>Define Name with a name of say
ITProblems and a RefersTo value of

=OFFSET($M$1,,,COUNTA($M:$M),1)

then just use =ITProblems in the Data Validation List textbox.

You button should just add the value to the bottom of the range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"harpscardiff" <[email protected]>
wrote in message
news:[email protected]...
 
H

harpscardiff

thanks for your reply - got most of your instructions, wasn't sure about
the button?? I dont have a button, I was hoping, in the validation list,
if i an option "add new", a prompt box could come up, you type it in and
then it adds it into the list?
 
Top