View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mike_vr mike_vr is offline
external usenet poster
 
Posts: 42
Default One pivot table for multiple worksheets/tabs

Hi there

Just a quick one pivot tables. Say I have multiple worksheets all with
35k lines or so, all with the same headings and data formats, is it possible
to create a pivot table that looks at all four tabs and sums them into one
table on one worksheet?

Thanks

Mike