• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Allowed to add only specific data

P

Pampos

Guest
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.
 

Attachments

  • Example.xlsx
    9 KB · Views: 3
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.
 

Attachments

  • 02-04-2022-CHANDOO-ALlowed-to-add-ONLY-specific-DATA.xlsx
    9.5 KB · Views: 1
Back
Top