Avatar of RichShare
RichShare
 asked on

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.
Microsoft Excel

Avatar of undefined
Last Comment
RichShare

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
jppinto

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
RichShare

ASKER
Thank you perfect,
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy