created a cell with validation not to accept invalid data. This seems to work
fine within the same sheet. BUT when invalid data is copied from another
sheet in the same cell using (Paste Special - values) , validation is not
performed.

any suggestions