Dependent drop down list with too much data to label

Catalina524

New Member
Joined
Dec 22, 2005
Messages
2
I have been reading up on the different methods of creating dependent lists and was looking at using the indirect command for a validation list, but I have 150 choices in the first box and each choice has a combination of
2-20 values, making the labeling method very time intensive to use. How could I create a combo box that would allow me to have the dependency without having to reformat all of my data?

Here's what I am talking about (on a different sheet I have three lists and the three categories, cargo, origin and destination):


Edited by firefytr; Reason: HTML Maker mispost; please read the FAQ.
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, Catalina524
Welcome to the Board !!!!!

this is rather confusing to my sense
can you clarify what you want to do exactly ?

please provide an example, telling us
where do you want to fill in your data ?
where is the "mainlist" ?
where are the "sublists" ?
how do you want to proceed ?

please keep it simple, don't try to solve your entire situation at once, but start with some little lists to test ...

kind regards,
Erik
 

Catalina524

New Member
Joined
Dec 22, 2005
Messages
2
Sorry for the confusion. I basically have three drop down lists that I am using the validation function on: Cargo, destination, and origin. Right now, the user can chose any cargo and any combo of destination and origin locations, but, in reality, they should not be able to choose certain locations when they select a cargo. That is the list I included in my previous post- the actual combinations of carg/destination/origin. So, what I need is for excel to limit the choices in the drop down depending on the what cargo is chosen. My problem is that there are a lot of potential combinations.

Thanks for helping ; )
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

Watch MrExcel Video

Forum statistics

Threads
1,118,541
Messages
5,572,801
Members
412,485
Latest member
mayankhb
Top