One method for handling the issue is with Data Validation. Debra
Dalgleish has a fairly extensive explanation on this.

http://www.contextures.com/xlDataVal01.html

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Tue, 23 Sep 2003 10:54:06 -0700, "Brad"
wrote:

I was wondering if there was a way for a user to fill a
cell from a pick list or pull down menu. The problem we
are experiencing is a number of people enter data into a
cell. For example, a customer is named Plus One Plating.
One person types in Plus One Platg Inc. Another one enters
in Plus 1 Plating. A third one enters in PlusOnePlating.
As you can tell, this makes quierys difficult. What I
would like to do is to have all operators putting in (or
picking) the same information. Is that possible?