Data Validation

[RaulDR]

Hi All,

I created a worksheet which has a validation that prevent duplicate entries.
The validation is working fine if the user types the value. My question is
how can I make excel to validate the values that the user copy from another
worksheet and paste to my worksheet.

Thanks!

 

[Rick Rothstein]

Are we talking about a specific range or anywhere on the sheet?

 

[RaulDR]

A specific column... I wanted to prevent the user from entering a value which
is already existing or in use. The data validation wors fine if I can force
the user to encode each values, I'm anticipating that they might copy the
data from other worksheet and paste that to my worksheet.

Thanks again.