Pivot table of data in more than one worksheet

[Rehan]

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

 

[JulieD]

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