Multiple data ranges pivot tables

[simonchatterton]

Hi

I keep my transaction data for my accounts in separate Excel 2007 worksheets - one per quarter year.

I have set up pivot tables to give me the ability to summarise data for each quarter

I now want to bring together the data across a whole year and be able to examine it by cost centre, payee etc.

I have tried to use the Pivot Table Multiple Data Range Option with no success as it only gives me one set of Row, Column, Value options

Is this me making a mistake or a limitation of the software? I dont want to get 2010 for Power Pivot

Any ideas how to do what I want to do simply - I dont want to consolidate data, nor change the order of my columns and want a dynamic solution where I can update the worksheet and get this refected (albeit after a refresh) in the summary pivot table.



any help v. welcome

Simon

 

[VoG]

This might help you http://www.contextures.com/xlPivot08.html

 

[simonchatterton]

Thanks for the swift post. I have looked at the Contextures site a few times on this matter and it may well be that I am being dense, however it doesn't seem to explain things particularly clearly and suggests to my mind that you can get more than one column of data to display however this doesn't match my experience. Have you successfully created multi-column Pivot Tables from disparate data sources?