excel 2013 create pivot table from pivot table

I found that the code was not generic and needed good amount of tweaking before it can be used in different cases. _ Author Debra Dalgleish Posted on SeptemAugCategories Pivot Tableįirst of all a big thanx to Debra for putting such an useful code. The master file contains macros, so be sure to enable those if you want to test the macros. The zipped file contains a folder with region files and the master file – Report.xlsm. In the Pivot Tables section, look for PT0033 – Pivot Table or Excel Table from Multiple Files

To download the new version of the sample file, please visit the Excel Sample Files page on my Contextures site. I also added a Clear Sheet button, to remove whatever is on the sheet, in case you want to start fresh. Now it has two “Create” buttons on the main sheet: So, I created a variation on Kirill’s macro, and I’ve uploaded a new version of the file. Instead of building a pivot table from the data, a few people asked if it was possible to create a worksheet table instead.

Then, select the files that you want to include (press the Ctrl key, and click on multiple files)Ī pivot table is created from all the data, and you can filter or sort the data, just as you would in any other pivot table. You just click the button to start the macro. His technique used a Union query in Microsoft Query, and you can see the details here.

A few years ago, Excel MVP Kirill Lapin shared his code to create a pivot table from identically structured tables in two or more Excel files.

Excel 2013 create pivot table from pivot table