List from a List

[Kapcha]

Hello,

I am working on excel from work so i unable to edit or access the source as some answers tell me to do.
Im looking to create a drop down list in cell G6 which will determine what option will be selected in the second list in G7.

For example.
G6 list will have Option 1,2,3,4,5,6,7,8,9 and then depending on what you select G7 will have 1.1,1.2,1.3 or 3.1, 3.2, 3.3 depending on first option.

Hope this makes sense and you can help.

regards

 

[pgc01]

Hi
Welcome to the board

Check here:

http://www.contextures.com/xldataval02.html

 

[Kapcha]

Worked great,

Appreciated