ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 289
- Office Version
- 365
- Platform
- Windows
Sirs,
Is there a way that data validation will work even if the value that should be validated is from copy and paste values?
For example,
I have a column that is set for data validation. where there should be no duplicate values. If input manually, the data validation works.
However, if the values to be inputted came from copy and paste. The data validation doesn't work.
Many thanks and your response is really appreciated.
Is there a way that data validation will work even if the value that should be validated is from copy and paste values?
For example,
I have a column that is set for data validation. where there should be no duplicate values. If input manually, the data validation works.
However, if the values to be inputted came from copy and paste. The data validation doesn't work.
Many thanks and your response is really appreciated.