Pivot Table - include multiple worksheets with different ranges.
 

I have a pivot table that I want to include source data from multiple
worksheets. the fields are the same in both but the ranges are different. I
have multiple worksheets because the numbers of rows is more then 65000
combined.
I used back on the pivot table wizard and tried to select both sheets and
ranges but it did not like it.

Pivot Table - include multiple worksheets with different ranges.
 

Hi Tracy

take a look at
http://www.contextures.com/xlPivot08.html


--

Regards
Roger Govier

"Tracy" wrote in message
...
I have a pivot table that I want to include source data from multiple
worksheets. the fields are the same in both but the ranges are different.
I
have multiple worksheets because the numbers of rows is more then 65000
combined.
I used back on the pivot table wizard and tried to select both sheets and
ranges but it did not like it.