If you know the basics of Excel Visual Basic (VBA), and have watched our
Excel Visual Basic (VBA) for Beginners series, it is time to take the next step. In this series, We take an everyday task – creating reports from a database – and look at how to complete it using Excel VBA. The series consists of 6 videos, including the introduction.
The series comes with a download file, and we recommend that you work along with the video. Click to download the Excel spreadsheet files below:
Video 1: Introduction
Video 2: Record Code to Duplicate Sheets
Video 3: Loops to Duplicate Sheets
Video 4: Loops and If to Delete Sheets
Video 5: Offset to Position Data
Video 6: Create Reports Using VBA – Full Demo
Have you completed the video series? How did you find it? If you develop confidence in these areas, it won’t just save you time, it will transform the way you work with Excel spreadsheets.