Is there a way to incorporate data from 2 worksheets into a single pivot table?? thanxx, klutzz
K Klutzz Nov 30, 2005 #1 Is there a way to incorporate data from 2 worksheets into a single pivot table?? thanxx, klutzz
R rsenn Nov 30, 2005 #2 Yes. Get there by Data > Pivot Table and Pivot Chart Report > Multipl Consolidation Range
D Debra Dalgleish Nov 30, 2005 #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
