Solved

PIVOT table from multiple sheets?

Posted on 2011-03-14
2
687 Views
Last Modified: 2013-11-05
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
Comment
Question by:singleton2787
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 35133335
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
 

Author Comment

by:singleton2787
ID: 35137815
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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question