Drop down list from another worksheet

  • Thread starter Thread starter hcronrath
  • Start date Start date
H

hcronrath

Hi,
I have two worksheets, and I want to create a drop down list on the second
sheet from a list of names on the first sheet. Does anyone know how to do
this?
Thanks!
 
Select the list on the second sheet and name it. "Mylist" or whatever.

In the Source box of the Data Val wizard enter =Mylist. Hit OK.

HTH
Regards,
Howard
 

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

Dependent drop down dynamic range formula, off sheet. 7
Drop Down with dynamic named range offsheet source list 14
Formatted cell column in drop down list 1
Drop down lists on multiple worksheets 2
Starting drop down lists at the top 1
excel 2003 drop-down box color changes how 2
use v lookup from a drop down list 5
Drop Down Lists 2007 10

Back
Top