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.