Hi,

The pivot table you see is doing exactly what I need it to do (with standard pivot table drop downs for rows and columns). My problem is that I'm effectively not allowed to show the "pivot table way of selecting data."

So, I need to apply Form Controls or Active X Controls to Pivot Table on another worksheet to drive the pivot table. Anyone know how I can do this? I tried attaching a print screen but not sure if it worked. Thanks!


pivot table needs control form.jpg