excel 宏 数据透视表_宏从多个文件创建Excel数据透视表

excel 宏 数据透视表

If you want to create a pivot table from data on different worksheets, you can use a Multiple Consolidation Ranges pivot table. However, that creates a pivot table with limited features and functionality. Last year, Excel MVP Kirill Lapin (aka KL) shared his brilliant code to create a Union query and build a fully functional pivot table from data on different worksheets.

如果要根据不同工作表上的数据创建数据透视表，则可以使用“ 多个合并范围”数据透视表 。 但是，这将创建具有有限特征和功能的数据透视表。 去年，Excel MVP Kirill Lapin(又名KL)分享了他出色的代码，以创建Union查询并根据不同工作表上的数据构建功能全面的数据透视表 。

Now, Kirill is back to share two more pivot table macros, and I'm sure you'll be impressed by both of them. In today's example, he's written a macro to create a pivot table from multiple