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

  • Thread starter Thread starter admin4225
  • Start date Start date
A

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?
 
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.
 
Thanks everybody for helping out! This is great - I'm glad I ran acros
this board
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel lookup across entire workbook 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Drop down menu 2
Code to hide rows if cell in another WS is ="No" 11
Drop down list hyperlink 4
Data Validation and drop-down list using IF, AND and what else? 8
Drop Down List 2

Back
Top