Names to appear in drop down menu (taken from another worksheet)

[admin4225]

If I have 2 worksheets open in Excel...
Worksheet 1 has all the data, and I want a column (say B) to have a
drop down menu in each cell to pull names that are listed on Worksheet
2 (column A). How do I do this?

 

[Guest]

Hi
Have a look at Data|Validation. There is an intro to it here:
http://www.contextures.com/xlDataVal01.html

 

[comish4lif]

Data Validation, but in the case of pulling the values from another
worksheet, there's a trick.

You have to define your list on sheet 2 as a named range: selecet the
cells, then click: INSERT | NAME | DEFINE.

Then back on sheet 1, click: DATA | VALIDATION and set Allow = list,
and the source "=NameOfRange" - where NameOfRange is the name you
defined in step 1.

 

[Bob Phillips]

or use INDIRECT

=INDIRECT("Sheet2!A1:A10")

 

[admin4225]

Thanks everybody for helping out! This is great - I'm glad I ran acros
this board