Data validation not working when copy paste values to the validated area

[Sreekumar m k]

Hello Friends,


If i copy and paste some values to the area where data validation applied, Excel did not validating it. That means validation happens only when we type the data manually. There is any solution for this? Please help me


Thanks

Sreekumar m k

 

[Luke M]

Check out this article:

http://www.j-walk.com/ss/excel/tips/tip98.htm