NonStopLeo
New Member
- Joined
- Mar 25, 2010
- Messages
- 38
Friends, I need a little help, if you can please do.
In below link, I have attached my sheet. In Column E, i have given a drop down list from where any value can be pasted. but whenever I copy some value from other sheet and paste, it is also accepting values other than listed in drop down list. I need some validation, that the value should be selected from drop down list only, if wrong value is pasted which is not in list, should not be accepted, only listed value should be accepted. thanks.
https://jumpshare.com/v/aXxA2jvq9ctYgvRmf7sb
In below link, I have attached my sheet. In Column E, i have given a drop down list from where any value can be pasted. but whenever I copy some value from other sheet and paste, it is also accepting values other than listed in drop down list. I need some validation, that the value should be selected from drop down list only, if wrong value is pasted which is not in list, should not be accepted, only listed value should be accepted. thanks.
https://jumpshare.com/v/aXxA2jvq9ctYgvRmf7sb
