WellingtonIS
asked on
Create A drop Down Menu in Excel 2013
I have a spreadsheet with currently 2 sheet. I'm trying to create a dropdown list of memebers in a group. I have about 20 groups with different members attached. I get to the point where I go to Data Validation source. I want my members on a seperate sheet and the dropdown to reflect the members in a column on that second sheet. I can't figure out how to define. It doesn't allow you to point to that sheet? I'm sure there's a formula but how do you define a range on a 3rd spreadsheet??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Its a really pain but it works.
You don't need to actually create a named Range in the newer versions of Excel, you can just place the range address in the List box, e.g.
=Sheet2!$A$1:$A$3
=Sheet2!$A$1:$A$3
Data-Validation-template.xlsx