Forum Discussion
Pivot Tables for Multiple Worksheets in one Workbook
I'm building a workbook that will have a LOT of worksheets, all with the same format, just data (numbers) from different months and years. I will need to be able to do a lot of calculating and manip...
Hi Carla,
Afraid my answer will be too abstract. What i'd do is to use Power Query (aka Get & Transform for Excel 2016) to load your data to data model and transform into the form you need; use PowerPivot (aka Power Pivot for Excel 2016) to build measures on these data; and return that back to Excel sheet as PowerPivots and PowerCharts. Even more better to use Power BI for interactive visualization.
The rest depends on concertings.