Hi,

I have names of 5 cities in validation in column A.
We get the drop down menu to select any of this 5 cities in column A.

At times I copy paste names of the cities from other database which is
not similar to the names entered in validation.

I want a formula with which colun A is protected and we can only enter
data that is there in validation. Copy pasting of other data in column
A should not be allowed.

Hope I am able to clear my doubts....

Cheers,
Mandeep


--
mandeepdhami4u
------------------------------------------------------------------------
mandeepdhami4u's Profile: http://www.excelforum.com/member.php...o&userid=35841
View this thread: http://www.excelforum.com/showthread...hreadid=556321