27.2 - Split a table into tables with 50 rows, via VBA
A follow-up to part 1 (video 27.1) where I used Power Query to do a similar thing.
My VBA solution instead splits rows into independent workbooks, and won't leave you with gross, empty tables.
00:00 - Explaining the logic
00:44 - Macro 1
05:08 - Global variables
05:31 - Macro 2
08:30 - Fixing mistakes
09:05 - More variables
09:47 - Ready to loop
11:10 - Mo' problems
11:30 - Application.Index
12:53 - Macro 2
16:35 - Timer
17:00 - Execution time
17:20 - Start had to be public...
17:40 - Close books...
18:50 - Run #1
19:27 - Run #2