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

Hi,
Assuming that all of your data is in a table. First u populate ur combo1 with option1, option2,... and so on, so that each option comes only once. (use this SQL statement->Select distinct option from table YourTableName)
Now user can select one option from combo1, now u have option1.
Now retreive all records from table having option1 and populate combo2 with these records. (Use this SQL to retreive records--> Select option2 from YourTableName where field=Option1)
Before populating combo2, u first clear combo2, otherwise for each selection in combo1 will populate combo2. Finally combo2 will be having more/duplicate records than it should have.

Answer 2

It sounds extra such as you ought to do this in get entry to instead of Excel. That appears like something which you extremely need to establish with a database question instead of attempting to make an exceedingly great extremely complicated Excel macro to do it.