Hi folks,

I have a worksheet where I have already prevented a user from copying and pasting a cell in a normal column into another cell in a column with data validation drop-downs.

The issue I'm now having is that a user is able to copy and paste a cell from a column with data validation into another cell in a column with data validation. Is there any way to prevent this??

Many thanks, Kieran