Thu, 5 Jul 2007 10:10:01 -0700 from cele25 <cele25
@discussions.microsoft.com:
if certain cells equal a name then i do not want other cells to have the same
name. For example: Cell B1 has NFL team names in a drop down menu, in cell C1
i do not want the same team to be selected as it was in B1.

Data Validation.

(You might want to get your keyboard fixed, too: the Shift key seems
to work only intermittently.)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/