Can I combine two worksheets into one pivot table?

G

Guest

I have two worksheets I want to build one pivot table from. There are 24
columns of data each. How do I do this? I have been trying multiple
consolidation ranges and its not working. I don't get the headers to choose
from when I try to create the table. I get Row, Column, value and page one
as options.

Thanks


Todd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with source spread across multiple worksheets 1
Help using Pivot Tables 5
How do I combine worksheets w/o enough rows to combine? 3
Merge 2 datasheets into single Pivot Table. 2
Pivot pulling Multiple tabs 2
working with multiple consolidation ranges. 1
Combine multiple ranges into one worksheet 1
Can I combine two huge worksheets into one pivot? 1

Top