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.
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.