ExcelBanter - Pivot shart referring to multiple sheets

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

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Pivot shart referring to multiple sheets (https://www.excelbanter.com/charts-charting-excel/35950-pivot-shart-referring-multiple-sheets.html)

Kanga

Pivot shart referring to multiple sheets

Hi,
I have 80000 rows of data that I had to split over two sheets because of the
line restrictions. Is there a way that I can build one pivot table referring
to both sheets?
The two sheets are build in the exact same way.
Thanks a lot.
Kanga

All times are GMT +1. The time now is 04:15 AM.