In the second video with our member Jorgen, we try to complete the task of transferring data from an 'import' file to a 'collation' or ongoing file.  If you're downloading data weekly or even daily for your football trading, you will know this kind of process well.  Can we automate it using Excel VBA?

To do so, we touch on a range of advanced VBA techniques.  Though the routine uses just a few lines of code, each is complex and powerful and requires foundational understanding.  So, don't be overwhelmed and don't try to understand everything if you are a beginner - perhaps focus on just a single concept such as Range(Range,Range) or the .Cells technique.

The session also illustrates the importance of regularly backing up / saving your file!  Chris commits a schoolboy error by failing to do this, and loses the completed file.  There was only one option ... to do it all again!  Which means you get to see the routine built twice in the VBA editor.  Practice makes perfect ...

Tools And Techniques