TigerVQ #4 Excel VBA to Copy Data to Worksheets - Full VBA Tutorial

Link to download files: Tiger Viewer Questions playlist Excel VBA for Beginners playlist Have you ever had to copy / paste data in Excel from one sheet to another? Perhaps you've had to copy / paste certain rows from a dataset to separate sheets. I am pretty sure you are not the only one who has found themselves frustrated in this situation. It takes SO much time! Surely there is a better way... We can use Excel VBA to copy data to sheets in Excel. In the video tutorial, we take an example (sent in by a subscriber to the Tiger mailing list) from the world of horse racing. The workbook contains details of horses in races from the past few years; the user wishes to be able to copy the horses from each race to a separate sheet. Sounds simple enough, right? It's a typical example and I'm absolutely sure you will have tried to do something similar at some point in your working life - I know I certainly have... ... in fact, I tried to do it for this tutorial (see the beginning of the video!). I copy / pasted a few entries onto separate sheets and was genuinely shocked at how much time (not to mention, energy!) this relatively simple task used up, and I soon gave up! I started thinking about how to exploit Excel VBA to copy data to sheets; the result was an awesome VBA routine that executes in just a couple of seconds. Yes, this manual task that takes up hours of your time can be reduced to just seconds. In the video, I walk you through the code, step-by-step, using...