How to Use Excel VBA Code - Real Example P1

How can we use Excel VBA code to speed up manual work in Excel? In this series we explore an example Excel VBA project sent in by Eric, a viewer of the channel. We aim to build an Excel VBA application to move data around a file at the 'click-of-a-button', saving hours of frustrating manual work. The application should be flexible and scaleable enough to handle changes in business circumstances - a challenge indeed! Let's get into it...

Download File Link:
https://tinyurl.com/y4d6ds62
---------------------------------------------------------
In part 1, we consider the task at hand and complete a simple task that moves us in the right direction. This may seem to lack ambition, but it is important to plan any VBA task and to move forward in easy steps; if you simply jump into the VBA editor, you are likely to get into trouble. We have all been in a coding tangle before!

We know we have to take data from four sheets in the file. So, a sensible first step would be to set up a mechanism to loop through sheets in the file. It's simple enough, and it sets us off in the right direction, and allows us (and our client?) to build trust and confidence. In the video, Chris uses a particular sheet referencing technique (using sheet index numbers) that allows us to quickly exclude sheets from the loop - since some of the sheets in the file do not contain data. We also look at how to set up the loop to cater for additional sheets in the file - remember our solution has to be flexible and scaleable.

With this relatively simple task complete, we are on our way! See you in part 2. Don't forget to let us know in the comments how you get on, Chris will get back to you.

Series Playlist Link:
https://tinyurl.com/y4pmrkxn

🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know
https://tinyurl.com/yc7jlmbs

  / tigerspreadsheetsolutions  
  / tigspreadsheets  
http://tigerspreadsheetsolutions.co.uk
Also on Insta :-)