Pivot : how to put more than one range of data in data area of a pivot table?
Y Yahýa Aug 7, 2006 #1 Pivot : how to put more than one range of data in data area of a pivot table?
D Debra Dalgleish Aug 7, 2006 #2 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
