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.

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

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