Drop down list from another worksheet
 

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!

Drop down list from another worksheet
 

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

"hcronrath" wrote in message
...
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!

Drop down list from another worksheet
 

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"hcronrath" wrote in message
...
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!