Dependent drop down list with too much data to label

[Catalina524]

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.

 

[erik.van.geit]

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]

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]

Sorry, couldn't get back till now.

you didn't post a simple example yet
(did you see your first post was edited by administration ?)

take a look at this "famous" thread
(the link is already pointed to the "most relevant post")

http://www.mrexcel.com/board2/viewt...=0&postorder=asc&highlight=cascading&start=26

for a technique using comboboxes
http://www.mrexcel.com/board2/viewtopic.php?t=152281&start=5

kind regards,
Erik