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.

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)


"RaulDR" wrote in message
...
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!