| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table
Hi,
How to use two or three sheets in a single pivot table. I have the data in multiple sheets and I require a single pivot with all the sheets. Regards, Igneshwara reddy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pivot table
It is possible to use multiple consolidation ranges in a pivot table,
however, there are restrictions. Look here for more information. http://www.contextures.com/xlPivot08.html My bet is the best advice is to consolidate your data onto one sheet. Regards, Fred. "Igneshwara reddy" wrote in message ... Hi, How to use two or three sheets in a single pivot table. I have the data in multiple sheets and I require a single pivot with all the sheets. Regards, Igneshwara reddy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
![Igneshwara reddy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
