would someone please tell me how to create a pivot table from 2 worksheets
instead of combining all data in one. The problem is the source fields. I'd
like to see my column headings but instead the source fields show up as Row,
Column, Value. I'd like to know how to get my column headings to be my
source fields so I can arrange them in a pivot table. Thanks.