Dynamic Drop Down Lists

[Az566]

I have a sheet with Group Name and Group ID, under which I have Sub ID numbers and Sub names. On another sheet I want to select the Group Name to get the list of Sub Names populated in a column.

For example:

[TABLE="width: 565"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Bob's Family[/TD]
[TD="align: right"]1289731[/TD]
[TD][/TD]
[TD]Paul's Family[/TD]
[TD="align: right"]98012309[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD]Paul[/TD]
[TD="align: right"]125[/TD]
[/TR]
[TR]
[TD]Andrea[/TD]
[TD="align: right"]37[/TD]
[TD][/TD]
[TD]Jimmy[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]Simon[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD]Samantha[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Paula[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD]Tim[/TD]
[TD="align: right"]85[/TD]
[/TR]
</tbody>[/TABLE]

If I select Bob's Family from the drop down list, I want the table below to be populated with all the names of Bob's family.

Been trying with arrays but since I don't know which column will be selected I can't seem to do it?

 

[VoG]

This may help you http://www.contextures.com/xlDataVal02.html