Excel 2003: Combobox shows list from another sheet

I have an Excel file with 2 worksheets. (i.e. "Sheet1" and "Sheet2")

on "Sheet1" I have a cell that shows a combobox.
(The combobox was created using Validation and selectin "Allow" "List")

Nonetheless, using "Validation" the list MUST be on the same sheet as the combobox..

I would prefer to put a list of names on another worksheet (i.e. "Sheet2") so that the user/administrator can insert/change names (on "Sheet2") and the new names will appear in the comboboxes on "Sheet1". How would I do this.

i.e. my goal is to have a combobox on "Sheet1" that automatically updates when a user updates the comboboxes list on "Sheet2"
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
>>Nonetheless, using "Validation" the list MUST be on the same sheet as the combobox..Not entirely true.  You can get around it by creating a Name, and then referring to the name in Validation.So, if you have a named range, MyList, that includes the elements you want for your dropdown, then in the Data Validation set up, use type List, and for Source use =MyList
Dave BrettVice President - Business EvaluationCommented:
<No points please>

See Debra's site for an example of the Name technique that Patrick references



Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.