Pivot Table - Can Data Range be on multiple worksheets?

A

AllieG

I am trying to compile all the data from distinct worksheets into 1 pivot
table. Each worksheet is a day. Within this tab, I am tracking different
subjects (in rows) and their number of errors, number of successes, and
totals. Each tab has the same format and amount of data.

I have tried different ways, but i am getting "Range is not valid" error.
Does anyone know how i can compile the data from all the worksheets into 1
pivot table?

Thanks!
 

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 - Can my data range be on multiple worksheets? 0
Create a chart from a table in word thats dynamic 0
Creating a Chart on form from selected data in query. 0
Pivot Table Counting Text Data 0
Consolidation Table from Different Excel Tabs with Different Format 1
Pivot Table - Row Label Combination 0
One pivot table for multiple worksheets/tabs 2
Excel 2007 vlookup with Pivot table 0

Top