How to force cell input from a List?

N

NightLord

On Sheet1, Column B, a name must be entered. I don't want folks typing the
name, though, because spelling is important.
Thus, on Sheet2 I have created a List with the names they can choose from.
How do I make Columb B in Sheet1 use a drop-down for all of it's Cells, and
ONLY accept input from that drop-down list?

Thanks much!
 
S

Sean Timmons

Highlight your list of names

Go to Insert - Name - Define...

Give it an easy to use name, say, Names

Go to your sheet1 cells

Data - Validation - choose "list" from the drop-down

Type =Names

Ta Da!
 
N

NightLord

Oh, for the love of god.
I was forgetting the equal sign. ARG! It's always the simple things.
Thanks much.
 
G

Gord Dibben

Can you tell me why I bothered to answer the same question in a post in
another news group?

I guess because you asked to me to help you with the problem.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
Validation - Force entry from drop down list 1
drop down list should remember selection. 6
How to read and find a name? 5
Data-Validation -List - Pick from a drop down menu 4
Creating a list from multiple (sometimes the same) codes 1
data validation list: how do i 'force' a user to enter data from the list? 4
Filter a Drop List ? 1

Top