Excel VBA: Automatically create a Large Dataset populated with Random Data | Build from scratch
Excel VBA: Automatically create a Large Dataset populated with Random Data | Build from scratch
Create a rule-based dataset filled with randomized data spanning as many rows as you want, all at the click of a button. We will be using this very dataset in future videos while exploring other VBA concepts.
#vba #learnvba #excelvba #excel #exceltutorial #exceltips
Skill Set: Intermediate Level
Learn many data manipulation tricks showcased in this video. We shall also, cover examples using Dictionary, For Loop, Do Until Loop, Chr Function in addition to the Random Function.
Code available at:
https://skillsandautomation.com/how-t...
Macro file can be downloaded from Github:
https://github.com/skillsandautomatio...
Microsoft Links shown in the video:
Random function
https://learn.microsoft.com/en-us/off...
Character Set for the Chr Function
https://docs.microsoft.com/en-us/offi...
00:00 Intro
00:36 Demo
03:04 Disclaimer (Shortcuts taken)
03:46 Random Function
06:51 Main Code (Basic Setup)
09:15 Random Number Generator (Custom Function)
10:57 Alpha Numeric Generator (Custom Function)
14:40 Main Code (Populate Date Column)
17:05 Main Code (Unique Invoice Numbers)
20:40 Main Code (Populate Random Choice from a List)
23:02 Main Code (Rest of the Logic)
