You can create a pivot table from data on separate sheets multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

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


Dean wrote:
I have three depots each running their own delivery schedule on their system,
I can access each system and produce a report detailing all the stores order
detail but want to be able to consolidate the info into one report.
Each depot is on a seperate server so has to be on seperate reports!

Is it possible to run a pivottable over the three reports (all in the same
workbook)?
If it's using the "Multiple consolidation Ranges" then I'm not having much
luck!

Can someone help please?

Thanks
Dean


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html