Data Validation - copy paste !

[Christoffer Bloch Andersen]

I need to be able to copy paste (special - values) in the range of where my
Data Validaton is, but by doing so it will override the DV.

Is it possible to copy paste in the DV field without destroying the DV
and also notify me if my copy paste violate the DV criteria?

 

[Matt Richardson]

I need to be able to copy paste (special - values) in the range of where my
Data Validaton is, but by doing so it will override the DV.

Is it possible to copy paste in the DV field without destroying the DV
and also notify me if my copy paste violate the DV criteria?

It's easy enough to paste into the DV field without destroying the DV,
just right click where you want to paste, choose Paste Special... and
then select values from the list. That will paste in the values and
leave the DV intact. It doesn't notify you if your paste violates the
criteria however - will look into this for you.

Regards,
Matt
http://teachr.blogspot.com

 

[xmux]

Hey, i tried with paste special, ok it keeps the Data Validation but
it doesnt notify me there is a wrong entry!
How can i check it?