ExcelBanter - How do I create a multi-worksheet pivot table?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I create a multi-worksheet pivot table? (https://www.excelbanter.com/excel-worksheet-functions/127403-how-do-i-create-multi-worksheet-pivot-table.html)

Holly

How do I create a multi-worksheet pivot table?

I can't get the fields (headings) to sort by selecting my source data from 10
worksheets. I can do it with 1 worksheet being the source. When I try to do a
multi-page pivot table the fields do not come up to be the same. Is there
something different that needs to be done for a multi-page pivot table?

ShaneDevenshire

How do I create a multi-worksheet pivot table?

Not clear on this question - All of my sorts seem to work in a multi-sheet
pt.
--
Cheers,
Shane Devenshire

"Holly" wrote:

I can't get the fields (headings) to sort by selecting my source data from 10
worksheets. I can do it with 1 worksheet being the source. When I try to do a
multi-page pivot table the fields do not come up to be the same. Is there
something different that needs to be done for a multi-page pivot table?

All times are GMT +1. The time now is 12:41 AM.