Validation....

Giganews Newsgroups
Subject: Validation....
Posted by:  mandeepdhami4u (mandeepdhami4u.2a3i8z_1151469902.1621@excelforum-nospam.com)
Date: Tue, 27 Jun 2006

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?action=getinfo&userid=35841
View this thread:http://www.excelforum.com/showthread.php?threadid=556321

Replies