Excel Pivot table Question
#1
Aye up,
Does any one know if it is possible to create a pivot table from source data on two or more worksheets in the same document?
I have tried the consolidate function (but it groups them together), holding down shift when selecting the source data (it comes up with an error cannot open source file, or something like that.
Have done some searching but could not find out if this is possible or not???????
Ta
Paul
Does any one know if it is possible to create a pivot table from source data on two or more worksheets in the same document?
I have tried the consolidate function (but it groups them together), holding down shift when selecting the source data (it comes up with an error cannot open source file, or something like that.
Have done some searching but could not find out if this is possible or not???????
Ta
Paul
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM