Data Consolidation Archives

Dynamic Pivot Table with Multiple Tables using Power Query

January 31, 2021January 31, 2021 PKComments Off

In this article, we have created a dynamic Pivot Table report from multiple tables. We have taken 4 different yearly Sales Table as given in below image- Multiple Sales Table [caption

Dashboard Power Pivot

Fully Automated Excel dashboard with multiple source files

April 12, 2020April 12, 2020 PKComments Off

In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power

VBA

Data Consolidation: Allow User to select files on Runtime

April 8, 2019March 1, 2023 PKComments Off

In this article, we will explain to you the Data Consolidation from multiple Excel files using Application.GetOpenFileName in VBA. You can easily allow the user to select multiple excel files