asked on 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"
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"
Microsoft Excel
Last Comment
Dave
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Debra's site for an example of the Name technique that Patrick references
http://www.contextures.com/xldataval01.html
Cheers
Dave