View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Pivot Tables using multiple worksheets

If anyone can help with this, then that would be great, as i have similar
models, where i want to combine data. I heard the max number of consolidated
ranges etc was 6.
Thanks
Matt

AlanMB wrote:
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


--
Matt Lynn

Message posted via http://www.officekb.com