ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation - copy paste ! (https://www.excelbanter.com/excel-worksheet-functions/219243-data-validation-copy-paste.html)

Christoffer Bloch Andersen

Data Validation - copy paste !

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

xmux

Data Validation - copy paste !

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?

All times are GMT +1. The time now is 08:13 PM.