Hi Sue

quick answer - yes
in the wizard choose multiple consolidation ranges
however, there are some limitations to how the data from multiple ranges can
be manipulated so you might need to give it a go to see if you can get the
outputs you want.


Cheers
JulieD

"SiouxieQ" wrote in message
...
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