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?
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?