Filter and List Question
I have a multi-tab report that contains information based on 20 different
branches, about 30 Sales Managers, and 280 sales reps. There is a worksheet called Rep-Summary that provides information based on a specific rep. Currently this worksheet is based on choosing the rep name from a combo box that references the information in a summary page that I update using monarch and import into this report, so this information is regularly changed though the structure stays the same. What I would like to do it first choose a branch or manager name and then have a second drop down that would only populate the reps that are in that location or report to that manager. Can this be done? |
Filter and List Question
Yes, it can be done.
For details visit http://www.contextures.com/xlDataVal02.html "Deb_Bear" wrote: I have a multi-tab report that contains information based on 20 different branches, about 30 Sales Managers, and 280 sales reps. There is a worksheet called Rep-Summary that provides information based on a specific rep. Currently this worksheet is based on choosing the rep name from a combo box that references the information in a summary page that I update using monarch and import into this report, so this information is regularly changed though the structure stays the same. What I would like to do it first choose a branch or manager name and then have a second drop down that would only populate the reps that are in that location or report to that manager. Can this be done? |
All times are GMT +1. The time now is 04:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com