Excel Pivot Table from Multiple Sheets

See how to create an pivot table from multiple sheets in Excel.
Get written steps and an Excel sample file on my Contextures site.
www.contextures.com/xlpivot08...
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: www.contextures.com/signup01
More Excel Tips and Tutorials: www.contextures.com/tiptech.html
Subscribe to Contextures RUclips: ruclips.net/user/contextu...
#contexturesexceltips
Video Timeline
0:00 Data on 2 Sheets
0:24 Open PivotTable Wizard
0:50 Select Sheet Ranges
1:08 Page Field Settings
1:29 Adjust the Pivot Table
2:04 Show Sum
2:15 Page Field

[@richardhay645]

Thanks for the Shortcut!!😊

[@contextures]

You're welcome, Richard, and thanks for your comment!

[@yassersaad757]

Excellent

[@contextures]

Thank you, Yasser!

[@barttitulaerexcelbart9400]

Hello Debra, thank you. This is a very old method (compared to PQ). Do you have any idea why Microsoft does not include this option (multiple data sources) in their regular (current) Pivot Tables?

[@contextures]

That's a good question, Bart, and I don't have an answer for you!