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"
See Debra's site for an example of the Name technique that Patrick references