Does anyone know how to create a single pivot table using many sheets
D Debra Dalgleish Feb 6, 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
