How to Create an Excel Pivot Table from Multiple Sheets

http://www.contextures.com/xlPivot08.html If Excel data is on different sheets, you can create a pivot table using multiple consolidation ranges. This video shows you the steps in Excel 2007, to create the pivot table and set up page fields.

To create a regular pivot table from data on multiple sheets, you can use a macro that creates a union query from all the data. There is a sample file to download at http://blog.contextures.com/archives/2009/08/24/create-a-pivot-table-from-mul...

Category:

Science & Technology

Tags:

• Excel
• Excel pivot table
• pivot table
• multiple consolidation ranges
• multiple sheets

[dgmailbag]

how do I access Pivot table wizard on mac????

[contextures]

@dgmailbag I don't have a Mac now, so can't test this, but try:  Cmd + Alt + P

[MoRrIx]

great...i'm working in something like this but what if i want to know how many black pens have been sold??? is that possible with a pivot table using multiple consolidation ranges??? Thanks!

[contextures]

@MoRrIx I've added a link in the video description, for a sample file that shows how to create a regular pivot table from data on multiple sheets.

[Keiko326Reo]

How can I do this with Excel 2010?

[cayala78]

thanks!!!  exactly what i was looking for!