Macro Archives - PK: An Excel Expert

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 a Chart Using Excel Range with VBA

March 23, 2019October 9, 2026 PKComments Off

Want to resize and relocate a chart using an Excel range in one keystroke instead of dragging its corners around? In this tutorial you build a short VBA macro that

VBA

Split Data into Separate Workbooks in Excel (VBA Macro)

July 15, 2018October 9, 2026 PK0

When one long sheet holds the data for many people, you often have to split data into separate workbooks, one file per supervisor, region or customer, so that each person