Excel: Is it possible to create a pivot table using source data from more than one worksheet? Excel 2007?
Excel: Iѕ іt possible tο mаkе a pivot table using source data frοm more thаn one worksheet аt once?
I саnnοt find thе Wizard οn Excel 2007- Wаѕ thаt removed?
MS, in its infinite wisdom of what users REALLY need and want, resolute to eliminate the wizard.
I reckon you can use a “collector” worksheet to pull the data from the various sheets into one so the Pivot table will work.
Yes you can make pivot using multiple Worksheets. But this function is not as bendable as you make pivot table using release sheet.
Sturcture of all the tables must remain same to take the benefit of this feature.
use upright small keys to aproach if you are using 2007 version otherwise the multiple table merging option may not be visile to you.
Press Alt + D followed by P
Select third option “Multiple Consolidation Ranges”
Click Next
Select “Select a Release Page Field for me”
Click Next
Now Select First array and Click on ADD
Add
and Select & Add as many ranges you want to consolidate.
Click Next/End
Now a Pivot is made using default fields.
Remeber Only First column values will be treated as row mark
and First Column Values will be treated as Columns.
you can drag Column values before and with only column values and can change the way of calculation for the column marks.
As I have already stated you that this is not much bendable function but still very useful. you can experience it yourself while using it.
http://xlxpart.blogspot.com