Hi, Is there any way to run pivot table with multiple worksheet (having same column and format)?
T TD Feb 13, 2007 #1 Hi, Is there any way to run pivot table with multiple worksheet (having same column and format)?
D Dave F Feb 13, 2007 #2 Select the "Multiple consolidation ranges" radio button in the first screen of the pivot table wizard. Dave
Select the "Multiple consolidation ranges" radio button in the first screen of the pivot table wizard. Dave
D Debra Dalgleish Feb 13, 2007 #3 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 here: http://www.contextures.com/xlPivot08.html
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 here: http://www.contextures.com/xlPivot08.html
