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
 
Back
Top