How do I specify multiple worksheets as data input for a single pivot table?
L Larry D Watts Dec 29, 2005 #1 How do I specify multiple worksheets as data input for a single pivot table?
G Gary L Brown Dec 29, 2005 #2 The first page of the Pivot Table Wizard has a 'Multiple Consolidation ranges' option. Choose this and follow the wizard. HTH,
The first page of the Pivot Table Wizard has a 'Multiple Consolidation ranges' option. Choose this and follow the wizard. HTH,
