Macro Archives - PK: An Excel Expert

VBA

Data Consolidation: Allow User to select files on Runtime

April 8, 2019March 11, 2025 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

Charts and Visualization VBA

Resize and Relocate the Chart using Excel Range

March 23, 2019September 17, 2024 PKComments Off

In this article you will learn a trick to resize and relocate a chart using VBA. We have created a shortcut key Shift+Ctrl+R to resize and relocate active chart. You

VBA

VBA: Split Data into Separate Workbooks

July 15, 2018February 28, 2025 PK0

In this article you will learn how we can split our data into multiple workbooks. Every workbook will be saved in the given folder path. This macro can be used