Excel VBA: Use Dynamic Arrays to Transfer Data and Build Dynamic Reports

Skills and Automation • June 27, 2021

Skills and Automation

About

Exploring automation possibilities beyond Excel. "Hello and welcome to Skills and Automation. My name is Ash and today, we are going to talk about ..." this Youtube channel! I started out in core Finance and over the last decade, I've have slowly transitioned into IT, operating in the space of Project Management, Business Intelligence and Process Improvement. Moving into IT from a non-IT background was hard. But, through a persistent pursuit of online research and courses (a lot of them!), I was able to push forward. The purpose of this channel is to help others learn better and faster. I hope to capitalize on my learned experience to post videos that are applicable in the real world. If this sounds interesting, please do consider subscribing and join me as we explore this domain. Code and related content will be posted to my blog site: https://skillsandautomation.com/

Latest Posts

Automate Excel with VBA & Google Gemini AI || Project - Summarize Comments

Skills and Automation

Excel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]

Skills and Automation

Video Description

We will build a macro where the end-user of the file can control how the columns from the source data need to be copied to our destination worksheet. They will be able to choose which columns to copy over and in what sequence. The macro will also, feature a vlookup style method of getting adjacent data from another worksheet based on a certain value in the current worksheet. For this video, we will only use dynamic arrays. Note: Dictionaries can be used to further optimize the code and we will use them in another video. Using dynamic arrays is much faster compared to looping over a data range on a worksheet. All the code will be built from scratch. It is available on my blogsite. Link below. https://skillsandautomation.com/useful-code/use-arrays-to-build-dynamic-reports-using-excel-vba/ You can download the macro file from Github: https://github.com/skillsandautomation/dynamic-arrays-transfer-data