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
|