Hello,

The data validation response i received on my intial posting worked when you
manually key in the same value preventing duplication but when i tried to
copy and paste the same value it ignored data validation and allowed a
duplicate entry. I need something that will worked weather manually keying or
copy and paste to prevent duplicates. Does this require VB or macro use?