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