Pivot Table - include multiple worksheets with different ranges.

T

Tracy

I have a pivot table that I want to include source data from multiple
worksheets. the fields are the same in both but the ranges are different. I
have multiple worksheets because the numbers of rows is more then 65000
combined.
I used back on the pivot table wizard and tried to select both sheets and
ranges but it did not like it.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Sorting Multiple Tables 1
Doughnut Chart linked with the slicer in the pivot table 0
Consolidate tables/ranges with text from multiple worksheets 1
Combine multiple ranges into one worksheet 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
One pivot table for multiple worksheets/tabs 2
Multiple Worksheets & PivotTable 1

Top