Pulldowns or pick lists for filling cells.
 

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?

Pulldowns or pick lists for filling cells.
 

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?