| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable based on multiple ranges or tables
If I have multiple ranges or tables on one worksheet, can I create a Pivot
Table based off of more than one range or table? For example, if a worksheet has the following tables/ranges: office1, office2, office3, and each table/range contains a list of equipment for each of those offices, can I use create a PivotTable that shows the "telephone" equipment from all three offices? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable Multiple Consolidaton Ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
| PivotTable - multiple consolidation ranges | Excel Discussion (Misc queries) | |||
| Pivot Tables with Multiple ranges | Excel Discussion (Misc queries) | |||
| Multiple Consolidation Ranges in pivot tables | Excel Worksheet Functions | |||
| PivotTable - Multiple Consolidation Ranges | Excel Worksheet Functions | |||
Threaded Mode
