Excel VBA: Manipulate Raw Data | Real Life Project to Re-Format Downloaded Employee Credit Card Data
Explore a real world Excel VBA project where we will convert downloaded data into the format that we are after. Learn how to loop over a dataset and read the data based on the current position of the loop.
#vba #learnvba #excelvba #excel #exceltutorial #exceltips
In this project, we will convert an extract of credit card transactions into a tabular format using Excel VBA. This technique of reading data can be applied to other scenarios as well e.g. extracting EDI information, reading PDF invoice data extracted in Excel or even, reading through downloaded articles.
We will learn about:
1. Nested For Loops: How to loop within a loop
2. Split Function: Split a text string into individual parts
3. Used Range: How to determine the range for a non-continuous data set
Skill Set: Intermediate Level
Video on ways to find last row:
https://skillsandautomation.com/usefu...
Code available at:
https://skillsandautomation.com/proje...
Macro file can be downloaded from Github:
https://github.com/skillsandautomatio...
00:00 Intro
00:22 Premise
02:56 Macro Build
22:16 Wrap Up