Thread: Data Validation - copy paste !

On 5 Feb, 12:44, Christoffer Bloch Andersen
<ChristofferBlochAnder...@discussions.microsoft.co m> wrote:
> 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?
>
> --
> Christoffer Bloch Andersen
> Trainee
> NNE Pharmaplan A/S

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