Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: heavnstrl
  • Content: Threads
  • Order by date
  1. heavnstrl

    Changing PivotField Summary Stats

    I use pivot tables in Excel XP extensively. When creating the pivot table through the wizard, excel 'automatically' determines how to summarize the data (either SUM or COUNT). I frequently use AVERAGE and have yet to find a way to set a default summarization type. Has anyone found a way to...
  2. heavnstrl

    Pivot Table source data reference in VBA

    I am creating a pivot table in which the data source (on a sheet named "results") has a variable number of rows. I can hard code the number of rows but would prefer to just refer to the 'used range' instead. The statement calling the pivot table currently looks like this...

Part and Inventory Search

Back
Top