Hello,
I am trying to create a dependent drop down list from data that is on multiple worksheet. I do not want to combine the data into 1 table or sheet. For example I have my main dropdown built with the following selections: Essential, Essential Plus, and Unlimited. When I select Essential I want to be able to select from a drop down list from a list of items in the Essential tab (worksheet). I want to do the same thing for each of the 3 different selections in my main drop down list.
Are the individual lists (i.e. "Essentials") congruous? i.e. Essentials list is in Sheet1!A1:A10, Unessentials is in Sheet2!C4:C18, etc.
If not, it needs to be, even if you do it on a hidden sheet.
If so, simply name the individual ranges using Name Manager and then, if your original dropdown is in A1, use
=INDIRECT(A1)
Does that help?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks