Pivot Table - Can my data range be on multiple worksheets?

A

AllieG

I am trying to compile data into one pivot table that appear on different
worksheets. For example, each worksheet tab is a distinct day. Within that
tab, I am tracking the errors, successes, and totals for multiple subjects.
Each subject is a row, with the number of errors, number of successes, and
totals as the columns.

Each day (worksheet) has the same format, and the same amount of data. Can I
sum all this information into one pivot table?
 

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