View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Macro for summarizing multiple sheets

Excel 2007 PivotTable, PivotChart
Consolidate tabs.
Filter by expiration date.
With macro.
http://www.mediafire.com/file/nanrmlyemnd/02_19_10.xlsm