Is there a way to copy data to a sheet and retain the data validation
criteria for the cells in that sheet? When I copy the data into the sheet it
overrides the data validation function. I would like to copy data to a row
and prompt the user if the data does't match. Ex: cell A3= ISTEXT(REVIEW)

Thanks