There's information on using multiple consolidation ranges he

http://www.contextures.com/xlPivot08.html

If you can use on table in Access, to store the data, that might be
easiest for you, then create the pivot table in Excel.

If you need to keep separate tables in Excel, you can use MS Query to
join the data, and create a normal pivot table. There's a sample file he

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'Multiple Consolidation Ranges'

SiouxieQ wrote:
Hi there,

Just a quick question to see if something can be done.

Can a pivot table be created from data in two seperate sheets?

Or is it best to export data to access and create some links and manipulate
it in queries there?

Cheers,

Sue


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html