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