How can I create a pivot table from multiple data sources

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.
RichShareAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
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
 
RichShareAuthor Commented:
Thank you perfect,
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.

All Courses

From novice to tech pro — start learning today.

Advertise Here