Excel VBA: Use SQL Group By Statement to Aggregate Data
Learn to use the SQL Group By statement to aggregate data in Excel VBA.
#vba #sql #learnvba #excelvba #excel #exceltutorial #exceltips
This is not just a specific video about Group By.
We will cover the broader topic of
1. How to use Excel like a database
2. How to use ADO or ActiveX Data Objects to connect to the Excel application
3. How to use SQL in Excel
4. How to aggregate multiple columns of data quickly and efficiently using Group By
5. How to sum data after aggregating it
So, in addition to the Group By clause, hopefully this video will open more possibilities for you to add to your coding arsenal.
All the code will be built from scratch. All the code in this video is available at:
https://skillsandautomation.com/usefu...
0:00 Intro
0:26 Topics Covered
1:05 Video Layout
2:17 Demo
3:27 Section 1: Code to Perform Group By
16:44 Section 2: De-Construct the Group By statement
26:46 Section 3: Error Handling
31:25 Section 4: Dump Results into an Array
