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?