| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Multiple worksheet Pivot Table
Hello,
I've got data that i'd like to put into a pivot table, but the data is over 65,000 rows...is there a way (other than access; b/c i don't know access) to make a pivot table out of 2-5 worksheets within the same workbook? Thanks!!! -JC |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Multiple worksheet Pivot Table
Hi
Choosing Data Pivottable, you see in the first screen appearing an option to consolidate ranges. Choose the 3rd option in that screen and select the different ranges in the following screens. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "JC" wrote: Hello, I've got data that i'd like to put into a pivot table, but the data is over 65,000 rows...is there a way (other than access; b/c i don't know access) to make a pivot table out of 2-5 worksheets within the same workbook? Thanks!!! -JC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
| how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
