T Tim Hagedorn Jun 25, 2003 #1 I would like to make a drop down menu based on a list that I have on a seperate sheet. How do I do that?
I would like to make a drop down menu based on a list that I have on a seperate sheet. How do I do that?
J John Wilson Jun 25, 2003 #2 Tim, Is this what you're looking for: http://www.contextures.com/xlDataVal01.html John
J J.E. McGimpsey Jun 25, 2003 #3 One way: Name your list (say, myList) Select the cell to have the dropdown. Choose Data/Validation/List and enter =myList in the Source textbox.
One way: Name your list (say, myList) Select the cell to have the dropdown. Choose Data/Validation/List and enter =myList in the Source textbox.
