VBA: Import external data to your workbook
ThatSoBasic.com
This is a basic example of how to import external data into your workbook. This particular example is based on importing data that's expected to be relatively the same day over day (which in many cases data tables can be pretty static). If you're working with a more variable data environment with data tables of unpredictable sizes and shapes, we'll cover that in a more advanced video later.