Instead of doing a <copy and then <paste to the destination cell, do
<copy, then move cursor to the destination cell and Edit | Paste
Special | Values (check) | OK then <Esc or <Enter. This will
preserve any formatting and data validation you have in the
destination cell.

Hope this helps.

Pete

On May 31, 8:48 pm, Angie wrote:
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