Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 701
  • Last Modified:

PIVOT table from multiple sheets?

In the attached spreadsheet, I am summarizing multiple sheets (Sheets 2 - 12) in the sheet Consolidated. There must be an easier way!? Can a PIVOT table be constructed across multiple sheets without reformatting the entire spreadsheet? The Sheet Byron probably has to be reformatted becuase it's different than the others?
Summary: Construct a PIVOT table on a new sheet using the data from Sheets 2-12, rows 5-8
thanks!!
Revised-Travel-Expenses-WIP.xlsx
0
singleton2787
Asked:
singleton2787
1 Solution
 
jppintoCommented:
Please read this:

http://www.contextures.com/xlPivot08.html

It explains how to build a Pivot Table with data from multiple sources.

Hope this is what you're looking for.

jppinto
0
 
singleton2787Author Commented:
Hmm..I think I got the consolidation to work. But the actual layout is all wonky. I just need to summaraize by Name, Month, and then Fields for Variance and Totals
Revised-Travel-Expenses-WIP.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now