Thread: Pull data from different worksheets/tab into one Pivot Table
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Pull data from different worksheets/tab into one Pivot Table
Excel 2007 Tables, PivotTable
Consolidate multiple Tables into Summary sheet,
as suggested by Jason.
Macro accepts unequal sized, random ordered Tables.
http://www.mediafire.com/file/2jo2yo...08_03_09a.xlsm
Reply With QuoteReply With Quote