How do you currently have it set up so if they choose all variables it works?

Are you using combo boxes, dependant drop downs, vba?
LMK

"Scott@CW" wrote:

I have a workbook that contain several sheets of data, one sheet for each
month and a report cover page. One the report cover page I would like to make
it were the user can choose the report based on seven different variables.
(State, SVP, VP, AVP, City, MGR, and AMGR). I can get it to work if they
select all variables, however I was hoping to make it work in a way that as
they select each variable to makes the calcualtions. Kind of like a drill
down report. Is this possible?