Can I create a secondary list based on items in the first tier list in Excel
workbook? eg. in the first tier list, I have different groups, when I choose
one group, I want to see another list of sub-groups under the group I
selected.

cheers
wei