View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AllieG AllieG is offline
external usenet poster
 
Posts: 2
Default Pivot Table - Can my data range be on multiple worksheets?

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?