Data Validation - copy paste !

  • Thread starter Thread starter Christoffer Bloch Andersen
  • Start date Start date
C

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?
 
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?
Click to expand...

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
 
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?
 
Back
Top