Pivot Table help
 

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

Pivot Table help
 

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