How to only drag values over when dragging data validation cells

[matt767]

Hi, is there a way to avoid dragging the entire contents other than cell value of a data validation cell (validation type, settings, message, etc.) into an adjacent cell with or without its own validation so that only the cell value gets copied over, but the target cell(s) keep their data validation contents/settings? In vba across workbook. Thanks

 

[Joe4]

You would probably have to do something with VBA.
But do ALL of the values you are dragging over into a new range meet the Data Validation Rules of the cells they are going to?
If not, I think you are going to have problems.