Blair has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Defining output range
Can you tell me how to use a form to ask a user to input which variable they would like a pivot table to provide. That is, one user could ask how much saleperson A sold in 2005, with another asking how much salesperson B sold in 2007, with all being user input.
Thanks
RE: defining output range
Hi Blair
To do this you would need to do the following:
1. Create the form with the required input methods (Text box or Combo box) to enter the fields to be displayed on the pivot table
2. In the program's module create Public variables to hold the information entered on the form
3. Write the Pivot table code using the variables in the PivotFields code lines
4. Place an OK buton on the form that when clicked passes the information entered to the variables and runs the Pivot Table code to create a Pivot table to reflect the requirements.
Hope this helps
Carlos
