Combo or List Box Based on another Combo or List Box

[jdawg_1989]

Hi,

I have data which is arranged in the following way:
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Manager</td><td style="font-weight: bold;;">Team Member</td><td style="font-weight: bold;;">Primary Role</td><td style="font-weight: bold;;">Secondary Role</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Elvis Presley</td><td style=";">Bart Simpson</td><td style=";">Stack Shelves</td><td style=";">Tills</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Joe Bloggs</td><td style=";">Lisa Simpson</td><td style=";">Stack Shelves</td><td style=";">Tills</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Elvis Presley</td><td style=";">Marge Simpson</td><td style=";">Stack Shelves</td><td style=";">Tills</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Elvis Presley</td><td style=";">Dave</td><td style=";">Stack Shelves</td><td style=";">Tills</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Joe Bloggs</td><td style=";">Bob</td><td style=";">Stack Shelves</td><td style=";">Tills</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Homer Simpson</td><td style=";">John</td><td style=";">Tills</td><td style=";">Stack Shelves</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">Elvis Presley</td><td style=";">Gary</td><td style=";">Tills</td><td style=";">Stack Shelves</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Elvis Presley</td><td style=";">Josh</td><td style=";">Tills</td><td style=";">Stack Shelves</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Homer Simpson</td><td style=";">Robby</td><td style=";">Tills</td><td style=";">Stack Shelves</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style=";">Homer Simpson</td><td style=";">Melinda</td><td style=";">Bakery</td><td style=";">Tills</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

I have a dashboard where I want to drill down on team members to view various details. The problem is that the team members list is quite large, so wanted to narrow the list returned by the manager selected.

So......

Combo Box 1: Manager List
Combo Box 2: Staff List (Based on Selection in Combo Box 1)

I'm open to other suggestions, as I'm sure there may be a better way to do this.

Thanks.

 

[VoG]

This might be an alternative http://www.contextures.com/xlDataVal02.html

 

[jdawg_1989]

This might be an alternative http://www.contextures.com/xlDataVal02.html

Thanks, Yes I did come across that link before I posted here. But I couldn't find a way to adapt it to my data.

The reason for this is the data comes to me in the format mentioned in my first post.

Thanks.