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

Top