Pivot table data source
 

Can anyone tell me if it is possible to crate a pivot table using data
sources from two separate worksheets. My source data is 0ver 80,000 rows, so
I had to split it to 2 worksheets.

Pivot table data source
 

You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

http://www.contextures.com/xlPivot08.html


FredH wrote:
Can anyone tell me if it is possible to crate a pivot table using data
sources from two separate worksheets. My source data is 0ver 80,000 rows, so
I had to split it to 2 worksheets.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html