Pivot Table to reference multiple sheets
 

I need to create a pivot table that references the data from 2 worksheets.
I have tried the consolidation method but am confused when the field list
does not carry over my column names.
Can someone please advise?
Thanks.

Pivot Table to reference multiple sheets
 

Using multiple consolidation ranges creates a pivot table with several
limitations, as described he

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

Perhaps you can move all the data to one sheet, or a database, as
suggested in the article.

massa wrote:
I need to create a pivot table that references the data from 2 worksheets.
I have tried the consolidation method but am confused when the field list
does not carry over my column names.
Can someone please advise?
Thanks.


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