Pivot table data source

[Guest]

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]

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 here:

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