Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot table of data in more than one worksheet
Hi
I have data whose numbers of rows exceed one worksheet.. ie. there are around 100,000 rows.. so I have this data in 2 worksheets.. the data is in continuation.. How can I pivot the data of both worksheets in one pivot table??? Thanks |
#2
|
|||
|
|||
Hi Rehan
this can be achieved using multiple consolidation ranges for your pivot table - check out http://www.contextures.com/xlPivot08.html for details Cheers JulieD "Rehan" wrote in message ... Hi I have data whose numbers of rows exceed one worksheet.. ie. there are around 100,000 rows.. so I have this data in 2 worksheets.. the data is in continuation.. How can I pivot the data of both worksheets in one pivot table??? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
Conditional Formating on calculated data in a pivot table | Excel Worksheet Functions | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
I am having problems creating pivot table of data | Charts and Charting in Excel | |||
Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) |