In this special video, recorded live with our member Jorgen, we look at how to collate data into a single file.  Football data can come from multiple different files / sources, so this could be a real time-saver for you!  With VBA, we can get it done (almost!) at the click of a button.

The task does not involve reams and reams of code, but the instructions we use certainly pack a punch! First, we look at how to open a file using Excel VBA, with the name of the file inputted in a cell in a worksheet.  Then, we deal with the tricky issue of selecting a data range to work with; since the amount of data in import files will change from week to week (or day to day,) we must set the routine up in a 'dynamic' way so that it works with any amount of data.

We will look to complete this task in the next special video with Jorgen.

Tools and Techniques: