Allowed to add only specific data

[Pampos]

Hello. I have a sheet Values and a sheet Data. In sheet Values there is a column A with some words. I want to be able to add only these word to sheet DATA column A. Not be allowed to add other word. Thanks.

 

[Marcilio]

Pampos, Good morning.

Have you tried using Data Validation?

It works exactly as you need it.
And it can even present an error message to the user if he tries to type information instead of just choosing a default data from the list.

Please, let us know if this is what you wanted.

Hope this helps.

 

[vletm]

Pampos
Something like this ...?
... only as You've given in Values-sheet ( capital letters )

 

[Pampos]

Thanks!!