We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
COURSE of the MONTH
15 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How can I create a pivot table from multiple data sources
Posted on 2011-03-09
I am trying to create a pivot table for sales to compare sales forecast against actual from various export markets. The data comes from two sources. In the past I have hard coded a table using lookup functions, etc. but when a new country comes along it requires new coding. Instinctively, I feel a pivot table would be the way to go but can't get to accept data from more than one range of cells.
[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
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month15 days, 7 hours left to enroll
743 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.