View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Consolidate Pivot table from multiple files

If you have multiple row fields or your column field
is listed in rows, then
Multiple Consolidation Ranges will not work.
You can consolidate your data on one sheet
using names that refer to the source data.
Maybe like this:
http://www.freefilehosting.net/download/3a5ea