| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - include multiple worksheets with different ranges.
I have a pivot table that I want to include source data from multiple
worksheets. the fields are the same in both but the ranges are different. I have multiple worksheets because the numbers of rows is more then 65000 combined. I used back on the pivot table wizard and tried to select both sheets and ranges but it did not like it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - include multiple worksheets with different ranges.
Hi Tracy
take a look at http://www.contextures.com/xlPivot08.html -- Regards Roger Govier "Tracy" wrote in message ... I have a pivot table that I want to include source data from multiple worksheets. the fields are the same in both but the ranges are different. I have multiple worksheets because the numbers of rows is more then 65000 combined. I used back on the pivot table wizard and tried to select both sheets and ranges but it did not like it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table from multiple ranges? (Revisited) | Excel Discussion (Misc queries) | |||
| Pivot Table-Multiple Consolidation Ranges | Excel Discussion (Misc queries) | |||
| creating a pivot table w/ ranges from 2 worksheets | Excel Discussion (Misc queries) | |||
| Pivot Table - Multiple Worksheets | Excel Worksheet Functions | |||
| Pivot Table-Using Multiple SS's or Ranges? | Excel Discussion (Misc queries) | |||
Linear Mode
