Hi I am trying to run SQL in EXcel on data stored in Sheet2 of same workbook.
I am tryting to fill a combo box using SQL queries ..The list populating is dependent
on selection made in another drop down.eg

A japan
B india
B UK
A germany
A italy
B France

so if A is selected I want the other combo box to be populated with japan,germany and Italy...
please help wth the code for running the SQL