| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Paste overides data validation
Hello,
The data validation response i received on my intial posting worked when you manually key in the same value preventing duplication but when i tried to copy and paste the same value it ignored data validation and allowed a duplicate entry. I need something that will worked weather manually keying or copy and paste to prevent duplicates. Does this require VB or macro use? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Paste overides data validation
look for paste special
using paste special u can retain validation setting of a sheet on which u are pasting.....selecting values only -- hemu "jk" wrote: Hello, The data validation response i received on my intial posting worked when you manually key in the same value preventing duplication but when i tried to copy and paste the same value it ignored data validation and allowed a duplicate entry. I need something that will worked weather manually keying or copy and paste to prevent duplicates. Does this require VB or macro use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - copy paste ! | Excel Worksheet Functions | |||
| Data Validation (copy paste error) | Excel Worksheet Functions | |||
| Data Validation (copy paste error) | Excel Worksheet Functions | |||
| problem data validation and copy/paste | Excel Worksheet Functions | |||
| Copy/Paste over rides data validation | Setting up and Configuration of Excel | |||
Linear Mode
