Forum Discussion
Pivot Table for use with multiple data sheets
I am trying to create an interactive graph for different area using a pivot table, but should be able to connect to different data set on different worksheets. Attached is my workbook with 2 datasets. I am using pivot table because I want to avoid to write simple program for it.
You may use PivotTable and PivotChart Wizard as described here Consolidate multiple worksheets into one PivotTable (microsoft.com)
in that section
as a first step you need to add it to QAT. Result is as in attached.
- Thank you for info and I am trying to digest it now.
