Excel Macro Class 4 - Looping Copying Deleting Data

Add to Favorites
Author: | Edits: don

This is a long tutorial, so bear with me. I explain everything in a very step-by-step manner.

Here, you will learn about the For Next loop, how to get the last row of data from a table with VBA, how to copy data, how to delete data, and how to do something with data based on specific criteria.

After this tutorial, you will know how you copy data between worksheets with ease and you should also be able to easily customize the sample file to work with your data and your needs.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.