Excel dependent drop down forms?

Question

I am trying to put together two combo boxes, Combo1 and Combo2, the content of Combo2 will depend on the selection made in Combo1, for example Combo1 will have 10 items, once an item is selected Combo2 will have different sub selections relating to that item. I know you can do this via Validation, but the problem with that I have about 4000 options in the combo1 and about 60000 in the second, here is the structure of my data:

First Option /Second Option
Option1_____1.1
Option1_____ 1.2
Option1_____ 1.3
Option2_____ 2.1
Option2_____ 2.2
Option2_____ 2.3
Option3_____ 3.1
Option3_____ 3.2
Option3_____ 3.3

My ultimate final result should look like this, two drop down menus once Option1 is selected second drop down form should display these options:

Option1 /_____ 1.1
____________ 1.2
____________ 1.3

Thanking in advance for your help,
Stan

see picture for complete clarity

http://www.excelforum.com/attachment.php?attachmentid=12929&d=1186890365

Answer 1

The following link will show you how to do what you need using data validation (no macros needed):
http://www.contextures.com/xlDataVal02.html

Answer 2

It sounds more like you need to do this in Access instead of Excel.

That sounds like something that you really need to set up with a database query instead of trying to make a really super ultra complicated Excel macro to do it.

Answer 3

gazing the cellular link assigned to the drop down enter this in the cells you desire the tackle and make contact with to look: =index( variety of drop down archives, drop down cellular link, column to return ) IOW, if the information in the drop down is in variety h1:i12, and the tackle is in i1:i12, and the drop down cellular link is a2 then: the index function will look like this: =index(h1:i12, a2, 9) the place a2 is the cellular link, 9 is the column to return. that's superb to apply a named variety on your drop down container archives.