Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |