| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help on pivot tables using external data sources | Excel Discussion (Misc queries) | |||
| pivot tables using two mdb data sources | Excel Worksheet Functions | |||
| Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) | |||
| create one pivot from mulitple data sources | Excel Discussion (Misc queries) | |||
| Pivot tables, external data sources and ODBC links | Excel Worksheet Functions | |||
Threaded Mode
