View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AlanMB AlanMB is offline
external usenet poster
 
Posts: 3
Default Pivot Tables using multiple worksheets

Hi,
I have a workbook with 12 worksheets (one for each month) with around 40,000
records in each. Is it possible to create a Pivot Table to enable me to
analyse the whole year?

Any help will be greatly appreciated. Thanks Alan