Hello everyone.
I have a workbook with multiple sheets and I want to create one pivot table using the data from all the sheets in it. I can create pivot tables on the individual sheets easily enough but not my 'super' pivot table. I get an error message when I try to select multiple sheets in the wizard.
The method I am using is to group all the required sheets (shift clicking) in the wizard and selecting raneg in just one of them.
Surely it must be possible to select data from multiple sheets. Any suggestions
Andrew299
It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)
I have a workbook with multiple sheets and I want to create one pivot table using the data from all the sheets in it. I can create pivot tables on the individual sheets easily enough but not my 'super' pivot table. I get an error message when I try to select multiple sheets in the wizard.
The method I am using is to group all the required sheets (shift clicking) in the wizard and selecting raneg in just one of them.
Surely it must be possible to select data from multiple sheets. Any suggestions
Andrew299
It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)