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?

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?