There will be occasions when a PivotTable needs to be created, however the data source is scattered in different worksheets and/or workbooks. Excel can consolidate this data first and then summarize into a single PivotTable report; via a feature called PivotTable and PivotChart Wizard.
Go to my Free Resources page to download a tip sheet.
A video tutorial on this topic is also available on the 'Free Resources' page.
Write a comment