ruclips.net/video/1m1rd_UWPT0/видео.html Dynamically Populating A Reusable Array While Looping Through A Table In VBA
A great question from Katerina. She has a huge data table, with various data sets segmented off into groups (like all sales from shop A could be lines 2-99, shop B could be 100-105, shop C 106-457 and so on. What we want to do here, is reuse the same array to read Shop A's data, then go away and perform some other clever stuff on THAT data block using code you have already written, then empty the array, and reuse it for shop B, than then C...and all the way until we have been through every variation.
The advantage in this approach is that you only need one array, and you can...