A lot of the average person’s workday involves boring and repetitive tasks. These tasks need to be performed multiple times and this is where Loop commands come in. Loop commands operate in a very similar manner to If statements in that once a certain set of criteria is met, the actions in the loop will execute. However, loops will continue to perform those actions repetitively until those conditions are no longer met. Loops are great for use in automations that involve data entry!
Basic Loop Commands
- Add Images/Words
This guide will discuss one of the basic uses of If statements, comparing two variables within an Excel file. - Practice Problem 1
This practice problem will cover the new commands covered in the previous chapter. Please review the previous chapter before attempting this problem.
Semi-Complex Loop Commands
- Counting Up
This guide will discuss one how the Begin Multi Loop command can be used to set up loops with multiple conditions. The guide will also discuss the use of the Next Loop and Exit Loop commands - Practice Problem 2
This practice problem will cover the new commands covered in the previous chapter. Please review the previous chapter before attempting this problem.
