View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Changing Pivot Table Data Source to multiple ranges

Excel 2007 PivotTable
With multiple consolidation ranges.
Add ranges.
http://c0444202.cdn.cloudfiles.racks.../12_23_09.xlsm