ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Data Sources (https://www.excelbanter.com/excel-discussion-misc-queries/140359-pivot-data-sources.html)

tojo107

Pivot Data Sources
 
I have a pivot that looks like this:

Catalogs
Data Data2 64 71 72 73 74
Circulation Forecast 10589 16381 11000 17381 11000 Budget 10589 16381 11000 17381 11000

The data for Forecast and Budget is in two separate tabs in my workbook. Can
I create a single pivot table that pulls from two tabs? I was able to do the
above by aggregating the data into a third tab, but this is not something I
want to do every day.

Thanks You!!



All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com