Data validation - when copied & pasted validation overlooked.

Hi Friends,

I validated the cells through data validation. Some with Lists, some with Max/Min values, etc.

Whereas, when we copy and paste data from other sources, the validated cell accepts any value.

for example: a column validated with a Gender list - BOY or GIRL.

When copied from other data, it accepts anything.

Can any one give suggestion.

acsishere.

See http://office.microsoft.com/en-us/ex...994291033.aspx