Combo or List Box Based on another Combo or List Box

jdawg_1989

New Member
Joined
Jun 24, 2011
Messages
27
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.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top