troubleshooting Question

Excel 2003: Combobox shows list from another sheet

Avatar of ouestque
ouestqueFlag for United States of America asked on
Microsoft Excel
2 Comments1 Solution358 ViewsLast Modified:
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"
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros